Memory Grants Pending

Hello there, everyone! I hope everything is going well for you. Today In this blog I am going to explain you about Memory Grants Pending and How to monitor it.

Memory Grants Pending-

The number of processes that are pending a workspace memory grant is known as Pending. Because they are unable to acquire adequate RAM while awaiting a grant, queries cannot begin. A persistent value of more than 2 can be a sign of memory pressure.

Here is a quick script which you run to identify value for your Memory Grants Pending.

Fig.1

With the help of this query you can easily find out the Memory Grants Pending

Fig.2

If this parameter is frequently higher than 0, your server may be under memory pressure and could benefit from more memory. Once more, this counter shows that your server may benefit from extra memory.