Allow Resource Governor to control the CAP of the TOTAL IO in MB/s
We need to define the maximum total disk throughput (MB/second instead of IOPS) per Resource Pool and to be able to cap the total maximum throughput on the SQL Server Instance level in Resource Governor.
The current offering of MAXIOPSPER_VOLUME allows us to control one common value across a number of different volumes, where IOPs is not a very constant, since SQL Server does a wide range of different block sized operations.
Niko Neugebauer
shared this idea
2 comments
-
Kamal
commented
We are facing this exact situation in AZURE SQL IaaS VM. The backup to blob basically maxes out the VM max throughput. We now have a requirement to implement ALWAYS-ON AGs. The solution recommended is increase the size of the VM type - but SQL license costs need to be taken into consideration.
-
Travis Page
commented
This is absolutely a critical need for cloud based VM workloads. Having a setting like this would help with facilitating restricted load testing scenarios, true shared resource pooling in heavily consolidated workloads or preparing for cloud migrations.