Post reply

What can I do to help my Memory Situation

  • July 31, 2006 at 9:54 am

    #191595

    Hi All,

    I curently have a pool of servers,

    Windows 2000 Server

    SQL 2000 Enterprise/SQL 2000 Standard on some

    4 x Xenon Cpu's each

    Around 4GB of RAM each.

    If I check under task manager, they seem to use 1.7GB max. I would like to increase this, as the servers are not used for anything else apart from being DB servers.

    What can I do ?

    Simple straight to the point answers please....

    Kindest Regards,

    John Burchel (Trainee Developer)

  • July 31, 2006 at 9:59 am

    #652414

    You need to look at AWE memory.

    Adventures in AWE

    LinkedIn Profile

  • July 31, 2006 at 10:18 am

    #652421

    With only 4GB of memory, you will not be able to use AWE.  Look at the /3GB switch in the link that David provided.  Keep in mind that this will not work on Windows 2000 Server Standard edition.  You must be on Advanced or Datacenter edition.  Using the /3GB switch will allow SQL Server to access approx. 2.7GB of the 4GB in each server.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

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

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