Memory Grants Pending Counter

On 01 Oct, 2015

MS SQL DBA

By : Charith Silva

No Comments

Memory Grants Pending Counter indicates the total number of processes waiting for a workspace memory grant. The recommended Memory Grants Pending value is zero, meaning no processes are waiting for the memory. Anything above 0 indicates that there are processes waiting for memory and that you should probably increase the memory allocated to SQL Server.

Here is the query that will return Memory Grants Pending Counter.

SELECT object_name, counter_name, cntr_value
FROM sys.dm_os_performance_counters
WHERE [object_name] LIKE '%Memory Manager%'
AND [counter_name] = 'Memory Grants Pending'

SELECT object_name, counter_name, cntr_value

FROM sys.dm_os_performance_counters

WHERE [object_name] LIKE '%Memory Manager%'

AND [counter_name] = 'Memory Grants Pending'

Previous Post Next Post

About The Author

Charith Silva

Charith Silva is a Microsoft certified SQL Server developer and database administrator who was graduated at Buckinghamshire New university in the UK. His career was started in 1998, primarily into Web application development, and later diversified into database development. He has got a vast experience in SQL Server database development, Database administration and Business Intelligence development. He believes that sharing the knowledge is key to the success.

Number of Posts : 87

All Posts by : Charith Silva