Search
Madeira Team
  • Oct 9, 2013
  • 3 min

How to Limit IO Requests with SQL Server 2014 Resource Governor

Resource Governor was introduced in SQL Server 2008 in order to allow us have better control over our system resource consumption. With Resource Governor, we can divide our users to groups, when each group gets a certain percent of our resources. That way, we can reduce the risk of a crazy query consuming all of the server resources and hurting other processes. The problem is that up and including SQL Server 2012, we could limit the amount of CPU and memory resources a certai