SQL Server Quickie #20 – CXPACKET Waits

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.)

Today I have uploaded the 20th SQL Server Quickie to YouTube. This time I’m talking about CXPACKET Waits in SQL Server.

Like or share to get the source code.

Thanks for watching!



  • Jeff Blackburn

    Thank you, Klaus. You have a gift of taking a complex topic and making it understandable.

  • Hi Klaus,

    Do you make available the code used in the video? For example, that endless proc?



  • Hi Klaus,
    I’m very very interested with your SQL Server #Quickie. It’s very good and simply understand. Can you give example about CXPacket Wait that we need to troubleshoot. Thanks

    • Klaus Aschenbrenner


      Thanks for your comment and your great feedback.
      It’s always fun to produce these SQL Server Quickies 🙂

      You can have for example a parallel scan on a partitioned table, where one partition is on a slower storage as another partition.



It`s your turn

Your email address will not be published. Required fields are marked *


Copyright © 2018 by SQLpassion e.U. · Imprint · Offerings · Academy · Contact · Data Protection · Go to Top