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!
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 firstname.lastname@example.org. 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.