Performance Optimization with SQL Server 2008

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.

Speaker

R Meyyappan is a SQL Server specialist with expertise in Performance Tuning. Ramesh worked at Microsoft Corporation from 1994 to 2004. Nearly half of that time he worked in Redmond in the development teams - specifically as Program Manager in the SQL Server Development Team responsible for optimizing SQL Server product for SAP. Ramesh now offers onsite and offsite consulting and workshops independently as well as by partnering with various Microsoft Subsidiaries. You can find webcasts from Ramesh at http://webcasts.sqlworkshops.com. You can contact Ramesh at rmeyyappan@sqlworkshops.com. To register for the upcoming workshops click

R Meyyappan's Sessions

Maximizing hardware utilization for performance & lower TCO

Monitoring and Tuning Parallel Query Execution

Performance Monitoring & Tuning - Documented Tips & Tricks

Monitoring and Tuning Parallel Query Execution - Part II

Performance Optimization with SQL Server 2008

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