Right-Sizing Row Mode Query Memory Requirements


In older versions of SQL Server (prior to SQL Server 2019, aka 15.x), SQL Server memory grant feedback supported was added, but only for batch mode queries. Queries that use batch mode performing scanning and calculations on up to 900 rows at a time, versus row mode that only processes one row at a time. With the introduction of version 15.x, memory grant feedback has been expanded to support row mode queries as well.

What is memory grant feedback? At a high level, memory grant feedback is the process of tuning the memory grant requirements of a given query based