What can I do about high CXPACKET waits?
3
votes
3
answers
3595
views
We are experiencing some slowness on our MS SQL Server 2016 database, I have been using Brent Ozar's first aid kit to do some initial troubleshooting.
I am seeing a high amounts of CXPACKET wait types, out of a 17.5 hour data sample we saw 99 hours of wait across our 10 CPU's, that 55.5%!
I was hoping someone here could confirm that we should be concerned about this number and resolve it asap. We have MAXDOP setting of 4 which is accurate to MS recommendations but our CTP is set to 5 which I believe needs to be changed to 50.
Just looking for clarification before I take this information to my boss, yes, I am new to database administration and yes I am looking at other wait types but this seems to be the most significant so far.
Cheers,
Josh
Asked by user3547606
(31 rep)
Jun 28, 2018, 03:55 AM
Last activity: Apr 14, 2025, 10:14 PM
Last activity: Apr 14, 2025, 10:14 PM