Microsoft® SQL Server® 2012 Bible

1135

Chapter 50: Resource Governor

50

8. Select New Resource Pool; a dialog box appears.


9. Scroll to the bottom of the Resource Pools list until you see an empty slot, as
   shown in Figure 50-1.

FIGURE 50-1

The Resource Governor Properties dialog box enables you to set the new resource

pool’s values.

10. Enter a name for the new resource pool.


11. Set the minimum and maximum CPU and memory values for the new resource pool.


12. Enter a workload group name for the resource pool.


13. Click the OK button.


14. Your resource pool is now created, but until you create a classifier function,
    Resource Governor cannot use it.
    Additionally, you can enable and disable the Resource Governor feature through script. You
    can use the following SQL Statements to disable or enable the Resource Governor:

ALTER RESOURCE GOVERNOR DISABLE; --Disables Resource Governor

ALTER RESOURCE GOVERNOR RECONFIGURE; --Enables Resource Governor

The next sections cover Workload Groups and the classifier function.

c50.indd 1135c50.indd 1135 7/31/2012 10:22:30 AM7/31/2012 10:22:30 AM

http://www.it-ebooks.info