6 thoughts on “SQL Server Quickie #20 – CXPACKET Waits”

1. 

   Jeff Blackburn

   12/09/2014 at 2:43 PM

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

   Reply
   1. 

      Klaus Aschenbrenner

      12/09/2014 at 2:55 PM

      Hello Jeff,

      Thanks for the great feedback, sir!

      -Klaus

      Reply
2. 

   Conrad

   03/02/2015 at 10:32 PM

   Hi Klaus,

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

   thanks,

   Conrad

   Reply
   1. 

      Klaus Aschenbrenner

      03/07/2015 at 6:42 PM

      Hello Conrad,

      You can download the source code directly on the blog posting itself: https://www.sqlpassion.at/archive/2014/12/01/sql-server-quickie-20-cxpacket-waits/

      Thanks,

      -Klaus

      Reply
3. 

   vinh

   05/26/2015 at 4:41 PM

   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

   Reply
   1. 

      Klaus Aschenbrenner

      05/26/2015 at 4:52 PM

      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

      Reply