May 11, 2005 at 8:09 am
The sqlservr.exe process is using up all the cpu time on one server which was perfectly fine before. I ran select * from sysprocesses where waittime > 0 order by waittime desc. One spid has a lastwaittype "CXPACKET" and a cpu time of -1874625197. Could this be the culprit? What else could I look for? Thanks.
May 11, 2005 at 8:15 am
Your SQL server is configured to use multiple processor to handle to queries, Turn it off from EM --> Processor --> Parallelism --> Use one processor.
May 11, 2005 at 8:20 am
is that usually a problem? what does a big negative value like that in the cpu column indicate? Thanks.
May 11, 2005 at 8:31 am
Some of queries do not work well when they run in parallel. Another option is to add query hint (option(MAXDOP 1) to force the query to run without parallel execution. Try it to see any improvement.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply