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

1 comment:

  1. SQL skills help data experts maintain, create and retrieve information from relational databases, which separate data into columns and rows. It also allows them to access, update, manipulate, insert and modify data efficiently. best SQL Courses

    ReplyDelete