Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning Stuck tracking down CXPACKET issue RE: Stuck tracking down CXPACKET issue
arnipetursson
SSCertifiable
Points: 6557
More actions
November 4, 2013 at 6:45 pm
#1664013
You can set MAXDOP to half the number of cores on your server if the instance is the only instance on the server.
Fewer if more than one instance is on your server.
That will prevent processes from taking over your instance.