From SQL2014, We can use resource governor to throttle the IO. Here are some limitation:
- Only for Database engine. Not for SSRS, SSIS and SSAS.
- No workload manger between SQL Server instance. That means it only can throttle its own instance.
- For short duration query, it may finish before bandwidth control comes in.
- Only for the user operation. Not for system operation, such as lazy writer.
- Can not ad IO thresholds to the infernal resource pool .