t-sql

SQL SERVER %26ndash; Queries Waiting for Memory Allocation to Execute
In one of the recent projects, I was asked to create a report of queries that are waiting for memory allocation. The reason was that we were doubtful regarding whether the memory was sufficient for the application. The following query can be useful in similar case. Queries that do not have to wait on a memory grant will not appear in the resultset of following query. SELECT�TEXT , query_plan , requested_memory_kb , granted_memory_kb , used_memory_kb , wait_order FROM sys.dm

Blog Content