Resource Governor in SQL Server

Resource Governor in SQL Server

In this post we will discuss about Resource Governor in SQL Server. In previous post we have learnt Switch Back to iOS after Jailbreak and How to Jailbreak iOS 7.1.2, iOS 7.1.1 and iOS 7.1.

What is Resource Governor:

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

By using Resource Governor, you can create a workload group mapped to a resource pool that governs how the resources are allocated. Resource pools and workload groups are explained in detail in next post.

How To Enable Resource Governor:

1. Open SSMS and connect to a server.
2. Open Object Explorer if it is not already open.
3. Expand the server tree.
4. Expand the Management folder.
5. Right-click Resource Governor and select Enable from the menu.

How To Enable Resource Governor

How To Enable Resource Governor Using TSQL:

---- Enable RESOURCE GOVERNOR ----

USE [master]
GO
ALTER RESOURCE GOVERNOR RECONFIGURE;
GO

How To Disable Resource Governor:

1. Open SSMS and connect to a server.
2. Open Object Explorer if it is not already open.
3. Expand the server tree.
4. Expand the Management folder.
5. Right-click Resource Governor and select Disable from the menu.

How To Disable Resource Governor Using TSQL:

---- Disable RESOURCE GOVERNOR ----

USE [master]
GO
ALTER RESOURCE GOVERNOR DISABLE;
GO