How will you Enable / Disable Resource Governor Using T-SQL in SQL Server 2008 ?

Posted by PandianS on 5/26/2010 | Category: Sql Server Interview questions | Views: 7132

Answer:

To Enable the Resource Governor :

Use DatabaseName

Go

ALTER RESOURCE GOVERNOR RECONFIGURE

To Disable the Resource Governor :

Use DatabaseName

Go

ALTER RESOURCE GOVERNOR DISABLE

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : what is the default port for Http and Https ?

Next > : What is the difference between Host_Name() and Ser ...

More Interview Questions by PandianS

Latest Interview Questions