Monitoring and Tuning Parallel Query Execution

In this session with examples we will cover how to identify inefficiencies in parallel query execution. We will also investigate some invisible symptoms! Keywords: MAXDOP, CXPACKET, SLEEP_TASK & SOS_SCHEDULER_YIELD. I don’t have a quad core laptop yet, so I will do the best with my dual core!

I don’t have a quad core laptop yet, so I will do the best with my dual core!

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!