Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2003
    Posts
    223

    Unanswered: Maximum memory problem

    Hello, everyone:

    I have SQL Server 2000 Standard Edition running on Windows 2000 Server. There are always memory full alter. I am going to configure that.

    I hope a clearation about a concept. In my enviroment, does SQL Server take maximum memroy upto 2GB, no matter if QWE is enabled?

    BOL said AWE is available only in the SQL Server 2000 Enterprise and Developer editions. Does it mean AWE cannot be configured on SQL Server 2000 Standard Edition?

    Thanks

    ZYT

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    It's suppose to do that

    What? You have other things running on the box?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Mar 2003
    Posts
    223
    Hi, Brett:

    No other application is running, only sql server. The physical memory is 4GB. There are alerts. The team in considering to add memory. But it is worried new memory is useless because sql server standard version only take 2GB.


    Quote Originally Posted by Brett Kaiser
    It's suppose to do that

    What? You have other things running on the box?

  4. #4
    Join Date
    Dec 2006
    Posts
    30
    Yes, AWE cannot be used with SQL Server 2000 Standard Edition. It's limited to 2GB of memory.

  5. #5
    Join Date
    Dec 2002
    Posts
    1,245
    Quote Originally Posted by nerdler
    Yes, AWE cannot be used with SQL Server 2000 Standard Edition. It's limited to 2GB of memory.
    Not only that, but he's running Windows 2000 Standard. OS Limit is 4GB. No benefit to running AWE on that platform.

    AWE is used once you get above 4GB RAM. To get >4 GB RAM, you will need:

    Windows 2000 Advanced Server (up to 8 GB RAM)
    Windows 2000 Datacenter (Can't remember the limit)
    Windows 2003 Enterprise (up to 32 GB RAM)
    Windows 2003 Datacenter (up to 64 GB RAM)

    Or you could go with Windows 2003 x64 and basically ignore your RAM limits.

    Regards,

    hmscott
    Have you hugged your backup today?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •