SQL Server Performance

Windows 2003 Ent SQL Server 2000 EE 8 gb RAM

Discussion in 'Performance Tuning for Hardware Configurations' started by adg1376, Sep 8, 2004.

  1. adg1376 New Member

    I have read through many of the treads concerning using more than 2GB of RAM for servers running W2K and greater. Everything seems to point towards the /3GB and /PAE. However on our server running Windows 2003 Server Enterprise Edition with 8 GB RAM, the SQL server will still only utilize under 2GB of RAM. Does the /3GB switch need to be used with /PAE? Are there other work-arounds for Windows 2003? Please advise soon

    -Andrew
  2. satya Moderator

    http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=5201 for reference.

    HTH

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. bradmcgehee New Member

  4. gkrishn New Member

    If u can detect 8GB from windows, means /PAE is enabled,already

    Only thing u need to do is configure AWE from SQL server and set max size to 6000 MB

    "if u need 7000 MB to sql server, i think u need to use /3GB wiht /PAE. I am still in this doubt becos, i wanna give 7000 GB to sql server."

    so lemme know if u get any solution





    Rajiv
    SQL-DBA
  5. aawara New Member

    I guess the greater confusion is about both /3GB and /PAE. If you are concerned by your system resources, i would by all means vote against /3gb as it cut your PTEs drastically. Just /PAE with AWE enabled would be sufficient. In win 2003 however, /3Gb becomes a lot more safe with /userva switch.
  6. derrickleggett New Member

    However on our server running Windows 2003 Server Enterprise Edition with 8 GB RAM, the SQL server will still only utilize under 2GB of RAM


    This is true IF you have SQL Server Standard Edition only. In that case, if it's a dedicated SQL Server, you're just wasting money having 8gb of RAM.

    MeanOldDBA
    derrickleggett@hotmail.com

    When life gives you a lemon, fire the DBA.

Share This Page