From the course: Microsoft SQL Server 2016: Installation and Administration
Join today to access over 25,300 courses taught by industry experts.
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…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.