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.
Presented by R Meyyappan at SQLBits IV
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO

    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 You can contact Ramesh at To register for the upcoming workshops click here / Microsoft UK TechNet. Ramesh has delivered the "3 Day Level 400 Microsoft SQL Server 2008 / 2005 Performance Monitoring & Tuning” Workshop in various countries in Europe including for Microsoft Austria / Microsoft Austria TechNet, Microsoft Belgium, Microsoft Czech Republic, Microsoft Denmark, Finland / Microsoft Finland TechNet, Microsoft Germany, Microsoft Netherlands, Microsoft Norway, Microsoft Poland, Microsoft Russia, Microsoft Slovakia, Microsoft Slovenia, Microsoft Sweden, Microsoft Switzerland and United Kingdom / Microsoft UK TechNet.
  • Video
    The video is not available to view online.