Questions tagged [resource-governor]
The resource-governor tag has no summary.
3 questions from the last 7 days
1
vote
1
answer
22
views
What does the Dedicated Admin Connection offer that Resource Governor does not?
The Question
What resources does the Dedicated Admin Connection reserve that I cannot reserve myself with Resource Governor? If I were a genius with Resource Governor, could I turn the Remote DAC off ...
- 1,398
1
vote
1
answer
24
views
How can I use Resource Governor purely as a monitoring tool?
It is clear that Resource Governor monitors how much work each group is doing. sys.dm_resource_governor_workload_groups makes this utterly obvious.
Suppose that:
I don't yet trust my ability to ...
- 1,398
0
votes
0
answers
8
views
Do queries blocked by Resource Governor's GROUP_MAX_REQUESTS not consume threads?
Do queries blocked by Resource Governor's GROUP_MAX_REQUESTS not consume threads? My demo below seems to suggest so, but I find this impossible.
Take a fresh server (you really don't want these ...
- 1,398