Microsoft® SQL Server™ 2008 All-In-One Desk Reference For Dummies®

VII.2.6. Enforcing Control with the Resource Governor

The previous sections of this chapter show you how to monitor your SQL Server performance passively. In this section, you get proactive and implement a set of throughput-related guidelines that SQL Server can enforce for you via the Resource Governor, a new feature available in SQL Server 2008.

The SQL Server Resource Governor delivers several key benefits to database administrators like you. These include

• Increased predictability and reliability of your SQL Server installation

• CPU and memory-based resource rationing

• Prevention of excessive resource consumption

• Activity prioritization

Using the Resource Governor to derive these advantages could easily consume its own dedicated chapter. Because space is limited, we focus on showing you how to set up the Resource Governor, along with how to best integrate it into your environment. As with many other topics in this book, we suggest that you explore this capability in more detail by using sample database and workload profiles. When you gain the understanding of how to use the Resource Governor, you'll be in great shape to deploy it in your environment. Finally, as with most of SQL Server's other administrative capabilities, you're free to use either the SQL Server Management Studio or direct entry via Transact-SQL. In keeping with the philosophy of this book, we emphasize using the graphically based SQL Server Management Studio because that provides a consistent and easier to understand ...