CXPacket Wait Type Count Investigation

Views 1568

High CXPacket Wait counts in an OLTP environment can be used as an indication towards performance issues relating to Query Parallelism in your environment due to having multiple cores available. As part of you investigation into determining if you need to adjust your MAXDOP (Max Degree of Parallelism) this script allows you to capture the various wait counts over time with changing the value of you MAXDOP setting.

The results from the process you can transpose across into Excel to use as evidence for you to justify your recommendations.

Windows-Live-Writer-CXPacket-Wait-Type-Count-Investigation_122C2-image_2

Leave a Reply

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

Warwick

I am a Microsoft Data Platform MVP as well as a Microsoft Certified Master working as the Principal Consultant here at SQL Masters Consulting. When I am not working with the SQL Server Stack I like to get away to the Snow and spend time Snowboarding.

Search