We’re rewarding the question askers & reputations are being recalculated! Read more.

Questions tagged [resource-governor]

The tag has no usage guidance.

4 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
0answers
165 views

Resource Governor IOPs counters - what are they counting?

When profiling a resource group that is known to be write-heavy, I am seeing a number of the "IOps write" counters remain at zero or increment unexpectedly. specifically, the following counters... ...
2
votes
1answer
78 views

SQL Server 2014, Volumes in Resource Governor

I'm looking at Resource Governor on 2014 and how it relates to volumes. I can see where to set up MAX|MIN IOPS PER VOLUME on a resource pool. That's not keyed by volume, however sys....
1
vote
0answers
392 views

Resource governor classifier function to find free pool

I have a SQL Server 2016 instance with around 30 db's. I want to equally distribute resources between them and I use Resource Governor for it. So, I created ~30 pools with the same settings, and my ...
1
vote
0answers
74 views

service broker/resource govenor

Is it possible to configure service broker to work with resource governor? Currently all commands are being sent to the internal group but I want them to go elsewhere.