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
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
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