Monitoring Resource Governor Memory Grants

We've been doing some performance testing of dimensional models and during these tests discovered that our resource governor was possibly throttling the CPU unexpectedly. After some research and digging, I found a few DMV's that would allow me to monitor the status of the resource governor, specifically in the area of memory grants. I wrote a custom query that pulls in several key items to help determine just who and what is working in specific pools in the resource governor. I hope you will find this query useful.

I hope you find this helpful,

Tim Parker