Post reply

sqlservr.exe taking too much memory

  • August 21, 2008 at 1:31 am

    #124978

    Hi All,

    We have sql server 2005 64 bit enterprise edition and we have a ram 3 GB. But i checked out the task manager and i saw that sqlservr.exe is using aroung 9 GB. Why is that?

    I should set the min/max setting? and how to avoid this problem?

    Pleasse help.

    Zombi

  • August 21, 2008 at 1:55 am

    #861070

    You should always set max memory on a 64 bit server. If you have 3 GB physical memory, set SQL's max to 2GB, no more.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 21, 2008 at 5:49 pm

    #861611

    Hi Gail,

    I will set the maz memory to the 2048 but how about the min memory? and if i set the max memory to 2048 does that affect the sql server performance?

    Thanks for ur reply.

    zombi

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply