I am using a tool to monitor SQL Server and Windows. It is waring me that: Process <<ERROR:no data>> has a virtual address space of 1,846.20 MB. This is close to the Windows two gigabyte address space limit. In Processes screen, I see: Process: sqlservr %CPU: 3.14 Mem Usage(MB): 167.79 VM Size(MB): 321.72 Handles: 2,847 Threads: 57 Page Faults/sec: 1.05 IO/sec: 25.21 Is this the process it is mentioning? What action should I take? CanadaDBA
What tool are you using? I believe 32-bit SQL process has a 2 or 3G address space... Read the following topic... http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=19498 Read the following blog.. http://blogs.msdn.com/slavao/archive/2005/01/27/361678.aspx http://blogs.msdn.com/slavao/archive/2005/01/26/360759.aspx MohammedU. Moderator SQL-Server-Performance.com
I rebooted my desktop and now the tool provides the <<ERROR:no data>> info. It is 1004<img src='/community/emoticons/emotion-7.gif' alt=':S' />ervices.<br /><br />When locate the process 1004, it shows 15 threads that Elapsed time for all of them is 1d, 3hrs. The Thread state is Waiting and the Thread Wait Reason is "Waiting for an Execution Delay to be resolved".<br /><br />I think that 1d, 3hrs is from the time I rebooted my server yesterday.<br /><br />Should I take action? How?<br /><br />CanadaDBA
Are you getting any performance hit lately with this error? If not I suggest to contact Vendor about such alerts or warnings. Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
i have said that i think all the performance monitoring tools are essentially worthless or an outright negative in that they give false positive warnings (generate a warning when nothing is wrong) give false negatives (not warn when there is a true problem) more later
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.73 services 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: Thread ID Elapsed Thread Wait Reason ------ ------- ---------------------------------------------- 1028 3d, 3hrs Waiting for an Execution Delay to be resolved 1032 3d, 3hrs Waiting for an Execution Delay to be resolved 1036 3d, 3hrsWaiting for a user request 1124 3d, 3hrsWaiting for an event pair low 1132 3d, 3hrsWaiting for an LPC Receive notice 1136 3d, 3hrsWaiting for a user request 1140 3d, 3hrsWaiting for an LPC Receive notice 1180 3d, 3hrsWaiting for an event pair low 1216 3d, 3hrsWaiting for a component of the Windows NT Executive 1276 3d, 3hrsWaiting for an LPC Receive notice 1336 3d, 3hrsWaiting for a component of the Windows NT Executive 1340 3d, 3hrs Waiting for a user request 972 3d, 3hrsWaiting for an LPC Receive notice 3592 3d, 3hrsWaiting for a user request 3596 3d, 3hrs Waiting for a user request 4744 1d, 8hrsWaiting for an event pair low 2224 0:09 Waiting for an Execution Delay to be resolved I don't know if I can or have to do somthing. CanadaDBA
