March 10, 2009 at 8:55 am
We have a server which CPU is flat lining every now and again.
we have traced it to be SQL related. And the clients are getting SQL Time out errors.
When I run sp_who2, there are many connections with a status "sleeping" and "Awaiting Command" and these connections have a high CPUTime value.
Thing that concerns me is that this CPUTime value keeps increasing.
Why is this?
I thought a "sleeping" process is something not to be worried about by what about the increase in CPUTime? Maybe I am not understanding it correctly.
Any help/advice?
March 10, 2009 at 9:02 am
The CPU time is cummulative so it is normal for it to keep increasing
March 10, 2009 at 9:10 am
Even though the status is "sleeping" ?
Could this be adding to the fact that the CPU is flat lining?
Can I kill these processes and will that solve my problem?
March 12, 2009 at 4:46 am
Yes.ofcourse you can.:)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply