Data Management

SQL Server 2008 R2: Predictable Response to Your Users

Date Added: Jun 2010
Format: Podcast

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.