SQL Server Performance

Server Memory.

Discussion in 'Performance Tuning for Hardware Configurations' started by krajdba, Jun 19, 2006.

  1. krajdba New Member

    Hi Guys,

    I have 6 GB RAM memory in the database Server. But for the most of the time it is using only 2 GB and rest 4 GB is used. Could you Please help how to make database to use that additional 4 GB and improve the speed.

    Very urgent Please.


  2. joechang New Member

    state your Windows version (2000 or 2003) and edition (Std, Adv, Ent), your SQL Server edition (Std or Enterprise)]

    then look in books online for PAE, AWE, etc
  3. Adriaan New Member

    You are running Enterprise Edition on Windows Advanced Server? AFAIK, you need that to access more than 2 GB of RAM.

    Also, if SQL doesn't require more than 2 GB of RAM, it won't take up more than 2 GB of RAM.
  4. satya Moderator

  5. krajdba New Member

    Hi guys

    I am using windows 2000, SQL Server edition (Enterprise) .


  6. satya Moderator

    Refer to the KBAs to use more than 2 GB in this case.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
  7. joechang New Member

    you really should learn how to use resources on the Microsoft site for these things

    assuming you have w2k adv server, you will need /PAE in boot.ini,
    lookup sp_configure for the awe setting,
    there might also be a permission involved, look in the sql server error logs after doing this
  8. krajdba New Member

    Hi Guys,

    Thanks, I got it.Thanks for all the help.


Share This Page