SQL Server Performance

Wind 2k3 Std 64 bit and SQL 2000 EE

Discussion in 'Performance Tuning for Hardware Configurations' started by DisTorTioN, Oct 7, 2005.

  1. DisTorTioN New Member

    New and stumbled into what is currently in place
    We have a Windows 2003 Std. 64 bit box (up to 32 GB RAM) and has 8 GB of RAM.
    AWE is enabled and is set to use 7 GB of memory but is only using 4 GB.
    From what i have read to get it to use more than 4 GB of memory i need to add the PAE switch to the boot.ini file. But i would like to confirm that before proceeding.
  2. derrickleggett New Member

    Is this the 64 bit version of SQL Server??

    MeanOldDBA
    derrickleggett@hotmail.com

    When life gives you a lemon, fire the DBA.
  3. DisTorTioN New Member

    no, for right now until we switch to SQL 2005, its the 32 bit version of 2000
  4. bertcord New Member

    pae is only required for 32bit os. What version of SQL Server are you running? Ent or Standard?

    I am running the following with 32GB of RAM

    Windows 2003 Enterprise x64
    SQL 2000 SP4 SP4

    IF you figure out how to use the counter logs to log SQL Server let me know....

    Bert
  5. DisTorTioN New Member

    its running on SQL 2000 Ent SP3
    ill see about the logs
  6. bertcord New Member

    I am suprised it is even working.... You need SP4 to run SQL2000 on a x64 box....Why dont you apply Service Pack 4?

    Bert
  7. DisTorTioN New Member

    my mistake it is running sp4
  8. joechang New Member

    i think you only need SP4 if you want support from MS, but still a good idea.
    you may need to enable AWE on SQL Server
    check the output of
    sp_configure 'awe enabled'
  9. DisTorTioN New Member

Share This Page