sql2000 CPU负载100%
sql2000 CPU占用100%
查询select * from master..sysprocesses发现有CXPACKET进程占用大量CPU
网上找到一个解决办法:
关闭sql server的并行机制:
sp_configure 'show advanced options',1
configure of override
sp_configure 'max degree of parallelism',1
configure of override
设置这两个选项以后发现CPU的下降的50%