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!

-Klaus

6 Comments

  • 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?

    thanks,

    Conrad

  • 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

      Hello,

      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.

      Thanks,

      -Klaus

It`s your turn

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

SQLpassion

Copyright © 2015 by SQLpassion · Klaus Aschenbrenner · Imprint · Offerings · Academy · Contact · Go to Top