Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I know I can use the performance counters to track Resource Governor CPU and Memory Usage. Is it possibly to track the I/O usage for each work load group? I haven't seen anything specific or any recommended practices.

share|improve this question
up vote 5 down vote accepted

Resource Governor does not manage I/O, it is just system resources for CPU and Memory. Therefore, I don't believe there would be any way to get I/O per workload group.

Quote from BOL on Resource Governor:

Resource Governor enables you to specify limits on the amount of CPU and memory that incoming application requests can use.

share|improve this answer
Correct there's no way to have Resource Governor manage IO. – mrdenny Apr 17 '12 at 18:28
I didn't think so, but thought I'd throw it out to the experts, hoping I missed something. Thanks. – HunterX3 Apr 17 '12 at 18:34

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.