liveBook · Manning

Memory grant feedback

As explained in 100 SQL Server Mistakes and How to Avoid Them

Memory grant feedback is an adaptive SQL Server feature that adjusts the memory allocated to a query based on execution history.

Memory grant feedback adapts the memory allocated to a query by using execution history. Query Store supports comparing plans and their associated performance, making adaptive feedback possible without immediately resorting to query hints. section 10.6 section 10.6

Apply these practical checks before relying on feedback:

  • Treat feedback as an adaptive alternative to reflexively adding query hints; verify whether the changing plan improves workload behavior. section 10.6

How 100 SQL Server Mistakes and How to Avoid Them covers it

How deep it goes
Defines adaptive feedback and its Query Store dependency, but stops short of detailing memory-grant adjustment mechanics.
Examples
Uses Query Store configuration and a large reporting-query performance scenario to illustrate adaptive feedback investigation.
What it assumes
Assumes basic SQL Server configuration knowledge and requires Query Store when following the feedback examples.
What you can do after
Evaluate adaptive query feedback with Query Store rather than assuming manual hints are the only remedy.
How it connects
Connects memory grant feedback with Query Store, query hints, execution plans, and intelligent query processing.
Cover of 100 SQL Server Mistakes and How to Avoid Them
liveBookmanning.com
Read 100 SQL Server Mistakes and How to Avoid Them on liveBook Get the book at manning.com

This explainer was generated by Manning's knowledge graph from the text of 100 SQL Server Mistakes and How to Avoid Them. The section links point to the parts of the book it draws on.