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.
Thanks for watching!
-Klaus
6 Comments
Thank you, Klaus. You have a gift of taking a complex topic and making it understandable.
Hello Jeff,
Thanks for the great feedback, sir!
-Klaus
Hi Klaus,
Do you make available the code used in the video? For example, that endless proc?
thanks,
Conrad
Hello Conrad,
You can download the source code directly on the blog posting itself: http://www.sqlpassion.at/archive/2014/12/01/sql-server-quickie-20-cxpacket-waits/
Thanks,
-Klaus
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
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