Chapter 26. Resource Governor
After completing this chapter, you will be able to
Use Resource Governor.
Enable and disable Resource Governor.
Create resource pools.
Configure Resource Governor to manage workload and resource consumption.
Create, register, and test classifier functions.
Modify Resource Governor configurations.
Similar to most relational database management systems (RDBMs), Microsoft SQL Server uses memory and CPU to handle its workloads. In some cases, a particular workload may or should have access to more of these resources than other workloads. For example, the CEO of an organization may run a memory-intensive report first thing in the morning. At the same time, other users may be running other workloads that are not as important. ...
Get Microsoft® SQL Server® 2012 Step by Step now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
