TechNet Webcast: 24 Hours of SQL Server 2008: Predictable Response to Your Users (Level 200)
Source: Microsoft Tips
At any given time, Contoso's servers provide multiple services to users and applications. Using Microsoft SQL Server 2008, Contoso would like to achieve better performance with its workloads. The presenter of this webcast takes a look at the Resource Governor, which enables administrators to define limits and assign priorities to individual workloads that are running on a SQL Server instance. The presenter also looks at Plan Freezing in SQL Server 2008, which enables greater query performance stability and predictability by providing new functionality to lock down query plans. This enables organizations to promote stable query plans across hardware server replacements, server upgrades, and production deployments.