CXPACKET Archives - Steve Stedman

CXCONSUMER and CXPACKET Waits.

By SteveStedman Posted on April 14, 2022 Posted in Database Health, Performance No Comments Tagged with cxconsumer, CXPACKET, cxpacket waits, Database Health Monitor, Database Health Reports, sql server performance, SQL Server wait times

CXCONSUMER and CXPACKET are associated with parallelism. When a query that has a cost beyond the cost threshold for parallelism then that query will be split out to be worked on by multiple cores. This is a good thing. It …

CXCONSUMER and CXPACKET Waits. Read more »

Database Health Monitor – Historic Waits

By SteveStedman Posted on July 9, 2015 Posted in Database Health No Comments Tagged with CPU, CTP, CXPACKET, Historic Waits, MAXDOP, Page Life Expectancy, SQL Server, Stedman Solutions

With the recent release of Database Health Monitor Version 2.0 I have decided to focus on of blogging about the features and benefits of the Database Health Monitor application. There are some incredibly valuable features that are often overlooked. The …

Database Health Monitor – Historic Waits Read more »

Tag: CXPACKET

CXCONSUMER and CXPACKET Waits.

Database Health Monitor – Historic Waits

Login