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,