How to Enable and Disable Resouce Governor in SQL Server - SQL Server DBA Tutorial

In this video you will learn how to enable and disable Resource Governor in SQL Server using SQL Server Management Studio as well as T-SQL Script. Best practices of using Resource Governor in SQL Server, when SQL Server Resource governor should be enabled and disabled.

Script to Enable and Disable Resource Governor

--Enable Resource Governor
ALTER RESOURCE GOVERNOR RECONFIGURE;
GO

---Disable Resource Governor

ALTER RESOURCE GOVERNOR Disable;
GO
 

Enable and Disable Resouce Governor in SQL Server - SQL Server DBA Tutorial