SQL Server 2008 R2: Predictable Response to Your Users

In this podcast, they explain how one can get better performance from Microsoft SQL Server workloads using two key features in SQL Server 2008 R2, Resource Governor and Plan Freezing. Resource Governor lets administrators define limits and assign priorities to individual workloads that are running on a SQL Server instance. Plan Freezing offers greater query performance stability and predictability by providing new functionality to lock down query plans, making it possible for organizations to promote stable query plans across hardware server replacements, server upgrades, and production deployments.

Provided by: Microsoft Topic: Data Management Date Added: Jun 2010 Format: Podcast

Download Now

Find By Topic