SQL Server Performance

task manager memory show wrong number in sqlservr.exe

Discussion in 'SQL Server 2005 Performance Tuning for Hardware' started by avipenina, May 28, 2008.

  1. avipenina New Member

    Hi,
    I've SQL Server 2005 Dev Edition and Windows Server 2003 ENT SP2.
    in the task manager i see that the server use 5GB out of 6GB,but when i arrange the process to see whom takes all the memory i see that the sqlservr.exe takes 150MB(he is the biggest).
    when i open Perfmon and look on the sqlservr.exe memory use, i see that he takes the 4.5G.
    i've a problem that the server use alot of cpu time to run users queries,i see that pages/sec counter is very big average between 600-800.
    is there any problem with my memory?
    why the memory reading from the task manager is wrong?
    if my pages/sec counter is so big do i have a memory leaks + pressure?
    THX
    avipenina, May 28, 2008
    #2

  2. satya Moderator

    Do you have any performance hit on this server, if so what it is?
    satya, May 28, 2008
    #3

  3. avipenina New Member

    what do you mean by performance hit?
    avipenina, May 28, 2008
    #4

  4. satya Moderator

    ANy performance issues or loss?
    satya, May 28, 2008
    #5

  5. avipenina New Member

    avipenina, May 30, 2008
    #6

Share This Page