Resource Governor

Published on October 21 2015 by LakshmiSaahul,Dhana Royal

Resource Governor

1. What is Resource governor?

Resource Governor is a feature which can manage SQL Server Workload and System Resource Consumption. We can limit the amount of CPU and memory consumption by limiting /governing /throttling on the SQL Server.

2. Why is resource governor required?

If there are different workloads running on SQL Server and each of the workload needs different resources or when workloads are competing for resources with each other and affecting the performance of the whole server resource governor is a very important task.

3. Does SQL Server have any default resource governor component?

Yes, SQL Server have two by default created resource governor component.

1) Internal –This is used by database engine exclusives and user have no control.

2) Default – This is used by all the workloads which are not assigned to any other group.

4. What are the major components of the resource governor?

Resource Pools
Workload Groups
Classification

In simple words here is what the process of resource governor is.

Create resource pool
Create a workload group
Create classification function based on the criteria specified
Enable Resource Governor with classification function

Let me further explain you the same with graphical image.