I have been trying to understand more in-depth how the resource governor resource pool limits work in conjunction with multiple user defined pools.
I've been trying to follow along the table in this MS doc: Resource Governor Resource Pool
But the formula explanations are a little vague (to my eyes) so I'm trying to make sure I am calculating the effective max and shared % numbers correctly.
The formulas in the comment column are for calculated effective max. Shared % seems fairly straightforward and dependent on the accuracy of the effective max. My questions are as follows:
- Do user defined resource pools consider the default pool in their calculations? I assumed they do because the default pool (from the MS example) considers the MIN values of user pools for the default pool calculation.
- Is it nonsensical as I believe for the SUM of all calculated shared % to be >100%? The MS examples all fall below 100%.
- Could someone please explain this blurb on shared % from the MS docs, I'm not fully understanding what the shared % calculation is supposed to represent:
The shared part of the pool is used to indicate where available resources can go if resources are available. However, when resources are consumed they go to the specified pool and are not shared. This may improve resource utilization in cases where there are no requests in a given pool and the resources configured to the pool can be freed up for other pools.
Lastly, the documentation mentions extreme cases of pool configuration and calls this out:
All pools have zero minimums. All the pools compete for available resources and their final sizes are based on resource consumption in each pool. Other factors such as policies play a role in shaping the final pool size.
Is that an accurate summation of the proposed pool configuration I have screencapped above? Hypothetically, this pool configuration would then allow the server to max out CPU and not meter CPU utilization as I intend, correct?
Thanks for the help.