Performance Optimization with SQL Server 2008

2009

TL; DR

Best Practice Guidelines for optimal performance while using the new SQL Server 2008 features: Filtered Index/Statistics, Resource Governor, Row Compression , Page Compression, Server Configuration Option: 'optimize for ad hoc workloads', Plan Freezing, Table-Valued Parameters, Disabling Table Lock Escalation, Transparent Data Encryption and more.

Session Details

3 things you'll get out of this session

Speaker

R Meyyappan's previous sessions

Maximizing hardware utilization for performance & lower TCO - 2012

Monitoring and Tuning Parallel Query Execution - 2010

Performance Monitoring & Tuning - Documented Tips & Tricks - 2010

Monitoring and Tuning Parallel Query Execution - Part II - 2010

Performance Optimization with SQL Server 2008 - 2009

Let’s make SQL fly - a technical session for developers and administrators who believe in magic! - 2009