Making Query Performance Rock-Solid with Microsoft SQL Server 2008

Play Making Query Performance Rock-Solid with Microsoft SQL Server 2008
Sign in to queue

Description

Are you worried about database query performance being consistent and reliable over time? The SQL Server team has added query plan freezing as a new building block for higher query performance reliability to SQL Server 2008. In this session, learn what the different use cases are that the new plan freezing functionality covers and learn how to implement the following scenarios using the new technology: -Keeping track of mission-critical query plans over time so that you can always go back to a well-performing query plan -Enforcing stable query plans across SQL Server upgrades -Testing query performance on a Q&A system and migrating the performance reliably to a production system -And, last but not least: top it off with combining plan freezing with the new resource governor functionality

Day:

0

Code:

08_NA_DAT3

Embed

Download

Download this episode

The Discussion

Add Your 2 Cents