SQL Server Quickie #20 – CXPACKET Waits

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

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

SQLpassion Performance Tuning Training Plan – Signup