SQL Server Performance

Questions About Task Manager Results

Discussion in 'ALL SQL SERVER QUESTIONS' started by jbates99, Jan 25, 2012.

  1. jbates99 Member

    Hi, I have SQL Server 2005 STD running on Windows Server 2003 and performance is slow at times.
    RAM: 8 GB
    4 Processors
    Paging File/Virtual Memory size is set to 2 GB

    Question 1: Task Manager shows PF Usage to be 2.7 GB and it is steady at near that amount. How can the actual Paging File usage be more than the specified 2 GB?
    Question 2: Task Manager shows that sqlservr.exe is using 1.5 GB of memory. (This is much more than my other SQL Servers which use around 300 MB.)
    Because this server is using so much more memory to run the sqlserver exe, does that indicate the server needs more RAM added?

    Thanks, John
  2. Luis Martin Moderator

    Task manager is not the tool to monitor SQL. TM exist only to maintain NT compatibility.
    Use Performance Manager.
    Search in our forum how to use it.
  3. jbates99 Member

    Thanks, Luis.

    I AM using Perfmon to monitor SQL Server. I was asking about the odd values I see in Task Manager on this server and why those values are so diffeher than those on all my other SQL Servers.
  4. Luis Martin Moderator

    As I said, Task Manager is not a good tool to measure any sql counter.
    So, I can't said why TM show some values in one server and different in others

Share This Page