You are the SQL administrator for your company. A SQL Server 2008 instance named Prod contains allproduction databases.
You use the Resource Governor to manage resource usage on Prod . You configure a new resource pool and workload group.
Later that day, you discover that the new workload is notbeing enforced. What should you do?
A.
Restart the Prod instance.
B.
Run the ALTER RESOURCE GOVERNOR RECONFIGURE statement.
C.
Run the ALTER RESOURCE GOVERNOR RESET STATISTICS statement.
D.
Restart the SQL Server service.
Explanation:
You should run the ALTER RESOURCE GOVERNOR RECONFIGURE statement. Whenever you changeResource Governor settings, including workload group or resource policy settings, you need to issue thisstatement for the changes to take effect. By default, the Resource Governor is not enabled. You should not restart the Prod instance. Restarting the instance will result in the old Resource Governor settingsbeing enforced. The Resource Governor must be explicitly reconfigured for the new settings to take affect. You should not run the ALTER RESOURCE GOVERNOR RESET STATISTICS statement. This statement onlyresets the Resource Governor statistics. It does not reconfigure the Resource Governor. You should not restart the SQL Server service. Restarting the service will result in the old Resource Governorsettings being enforced. The Resource Governor must be explicitly reconfigured for the new settings to takeaffect.
Objective:
Optimizing SQL Server PerformanceSub-Objective:
Implement Resource Governor.References:
TechNet > TechNet Library > Server Products and Technologies > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Database Engine > Technical Reference > Transact-SQLReference > ALTER RESOURCE GOVERNOR (Transact-SQL)