SQL Server Performance

Process memory usage

Discussion in 'Third Party Tools' started by CanadaDBA, Feb 21, 2007.

  1. CanadaDBA New Member

    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
  2. MohammedU New Member

  3. CanadaDBA New Member

    I am evaluating Quest Spotlight.

    CanadaDBA
  4. CanadaDBA New Member

    I rebooted my desktop and now the tool provides the &lt;&lt;ERROR:no data&gt;&gt; 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
  5. satya Moderator

    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.
  6. joechang New Member

    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
  7. CanadaDBA New Member

    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

Share This Page