Summary
Resource Governor is an extremely useful tool to prevent run-away queries. In addition, it can prevent many DBA nightmares. Judicious use of the Resource Governor allows you to dynamically control resource CPU and memory allocations for queries, which allows you to control your environments proactively rather than reactively. This granular control of resource allocation becomes critical in consolidated environments, such as shared instances or private cloud.
Get Microsoft SQL Server 2012 Bible 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.
