Questions tagged [memory-grant-feedback]

Use for questions regarding Batch Mode Memory Grant Feedback in SQL Server 2017

Filter by
Sorted by
Tagged with
4
votes
1answer
4k views

MSSQL - Query had to wait for memory grant

How do I go about troubleshooting an SP that times out every once in a while. When you include the actual execution plan, it says "The query had to wait for XXs for memory grant" This does not happen ...
3
votes
1answer
785 views

SQL Server 2017: How does Batch Mode Memory Grant Feedback Work?

Batch Mode Memory Grant Feedback is part of a family of features in the 2017 query processor that consists of: Batch Mode Adaptive Joins Interleaved Execution Batch Mode Memory Grant Feedback So ...