This machine is dedicated to SQL server. It is strange to me too. Here is the data from processes window:Process %CPU Mem Usage(MB) VM Size(MB) ---------- ---- ------------ -----------sqlserver 1.32 215.70 330.73services 0.34 3.94 4.71
And still I am getting the message I wrote in my original post. The services has 17 threads that most of them have "waiting" status. I see different reasons for each line: ThreadID Elapsed Thread Wait Reason------ ------- ----------------------------------------------1028 3d, 3hrs Waiting for an Execution Delay to be resolved1032 3d, 3hrs Waiting for an Execution Delay to be resolved1036 3d, 3hrs Waiting for a user request1124 3d, 3hrs Waiting for an event pair low1132 3d, 3hrs Waiting for an LPC Receive notice1136 3d, 3hrs Waiting for a user request1140 3d, 3hrs Waiting for an LPC Receive notice1180 3d, 3hrs Waiting for an event pair low1216 3d, 3hrs Waiting for a component of the Windows NT Executive1276 3d, 3hrs Waiting for an LPC Receive notice1336 3d, 3hrs Waiting for a component of the Windows NT Executive1340 3d, 3hrs Waiting for a user request 972 3d, 3hrs Waiting for an LPC Receive notice3592 3d, 3hrs Waiting for a user request3596 3d, 3hrs Waiting for a user request4744 1d, 8hrs Waiting for an event pair low2224 0:09 Waiting for an Execution Delay to be resolved
I don't know if I can or have to do somthing.quote:
Originally posted by mcrowley
Sounds like a memory leak somewhere. I would have expected that to be either sqlservr.exe or Exchange. Is there a web server on this machine?
Process memory usage
Posted - 2007-02-21 : 11:40:58
