Network Management

CXPACKET SQL WAIT Stats

This content will describe SQL Server wait type that can be encountered more or less commonly, which includes the description, steps that should be taken, and additional resources that could be used for troubleshooting.

First published date

10/8/2021 12:39 PM

Last published date

10/8/2021 12:39 PM

Overview

Indicates that SQL is waiting on a Parallel process to complete. This can be a sign of resource issues on the SQL server (CPU, MEM, DiskIO) or the query itself is poorly written. 

Product section

Network Performance Monitor

Cause

Description

A lot of the long-running queries are being parallelized. This is not necessarily a bad thing but it does consume additional CPU resources. If processor utilization is very high (typically above 80%) this wait should be investigated

Resolution

Suggested solutions

  1. Examine high CPU queries to see if they can be optimized.
  2. Investigate changing default MAXDOP and parallelism settings (links below)
  3. Indexing, look for high CPU parallel queries

The content posted herein are provided as a suggestion or recommendation to you for your internal use. The information set forth herein may come from third party website or customers. SolarWinds is not liable for any downtime or any issue that may occur if you perform the following suggestions on the link provided. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment.