From the course: Microsoft SQL Server 2016: Installation and Administration
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Resource governor - SQL Server Tutorial
From the course: Microsoft SQL Server 2016: Installation and Administration
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…