Performance Implications of Parallelism

Wednesday, December 5th, 2012 12:00 PM Central Time

Parallelism is a key factor in the performance of large queries. It allows SQL Server to perform a large operation quickly and yet at other times can appear to hinder performance. It is a complex topic that can often be difficult to troubleshoot and tune. This session will explain the how parallelism works, why it is good, and when it is bad. Some of the key takeaways will be:

  • What are CXPacket waits and should we care about them?
  • How parallel tasks are scheduled
  • How to read a parallel execution plan
  • How developers can tune for parallelism
  • How DBAs can tune for parallelism



Event Registration

Rate and Comment
  Confirm Conference Registration Selection
Performance Implications of Parallelism
EVENT is Closed
Rate and Comment
Rate and Comment
  Please Confirm Your Information
Rate and Comment
Updating Registration
Submitting Registration



    Robert L.  Davis

    Robert L. Davis is a Microsoft MVP, SQL Server 2008 Certified Master, an experienced DBA, evangelist, speaker, writer, trainer, and consultant. He is the Principal DBA with Outerwall, Inc. and consults part-time via SQL DBA Master. He has worked with SQL Server for more than 13 years, including recent stints as a Sr. Product Consultant and Chief SQL Server Evangelist for Idera Software, Program Manager for the SQL Server Certified Master Program at Microsoft Learning, and as a production DBA at Microsoft.

Conference Registration

  • Your registration includes:
    • On-demand viewing for 30 days following the event
    • Access to the virtual event video content
    • Live, interactive chat with other attendees, speakers and sponsors
    Not sure you can attend? No problem, all the video content will be available on-demand for 30 days.