From the course: Microsoft SQL Server 2016: Installation and Administration

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Resource governor

Resource governor - SQL Server Tutorial

From the course: Microsoft SQL Server 2016: Installation and Administration

Start my 1-month free trial

Resource governor

“

- [Instructor] Rather than letting the SQL Server instance consume all of the CPU, IO, and other resources on a server, you can choose to limit or restrict its activities when consuming resources. SQL Server Resource Governor is a feature that you can use to manage SQL Server workload and system resource consumption. It's important to note that the Resource Governor is only available in the SQL Server Enterprise edition. It allows you to manage your SQL Server workloads by specifying limits on resource consumption for incoming requests. There are various tasks and constraints that are applied to the usage of Resource Governor, and to gain a better understanding of what those are specifically, we should take a look at the Resource Governor page on MSDN, and take a look at the benefits of the Resource Governor where it covers what you can do with the Resource Governor. But equally important, it also specifies some of the constraints around the use of the Resource Governor itself. So…

Contents