Configure SQL Server Resource Governor to Manage CPU, Memory and I/O

SQL Server Resource Governor is a feature that can be used to manage SQL Server workload and system resource consumption. Resource Governor enables us to specify limits on the amount of CPU, physical IO, and memory that incoming application requests can use.