Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning CXPACKET wait type RE: CXPACKET wait type
Chris Burton-434978
SSC Veteran
Points: 253
More actions
December 4, 2012 at 2:55 am
#1565179
Whilst reducing the number of Processors used will reduce parallelism waits it may not be the best way to 'fix' the query ie. there are probably other underlying issues
A good link on the 'barking dog analogy'
http://www.sqlsoldier.com/wp/sqlserver/thebarkingdoganalogy