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

Comments or Responses

Login to post response