Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning CXPACKET wait type RE: CXPACKET wait type
chileu17
Hall of Fame
Points: 3093
More actions
October 16, 2008 at 2:15 pm
#886107
Hi everyone I am having a similar problem here, well on my dev server I have 4 cpu, I dunno why I get so much CXPACKET wait time, well my maxdop is 0, should I set it to 2? so I can get a better performance?
Thanks for your help,