Sample Header Ad - 728x90

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