Results 1 to 9 of 9
  1. #1
    Join Date
    Aug 2007
    Posts
    3

    Unanswered: SQL Server 2000 not using all memory allocated to it.

    One of our servers has 20GB of memory and SQL server has been allocated 18.5 GB out of it, however SQL Server only uses about 9GB or so.

    OS: Windows 2003 Server
    MS SQL Server 2000 SP4
    awe enabled
    min & max server memory (run values) are: 18432
    /PAE switch in boot.ini

    any help why SQL server is not using 18.5 GB allocated to it, would be greatly appreciated?

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    It will use what it needs...how big is the database?

    I'm guessing 9gb
    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
    Aug 2007
    Posts
    3
    Hi Brett, database is 110 GB

  4. #4
    Join Date
    Dec 2002
    Posts
    1,245
    Quote Originally Posted by sbajaj
    Hi Brett, database is 110 GB
    Which version of SP4?

    The original version (8.00.2039) had a bug in it that caused the amount of AWE to be cut in half. See http://support.microsoft.com/kb/899761/.

    Regards,

    hmscott

    Also, you might be interested in this:
    http://support.microsoft.com/?kbid=894905

    hmscott
    Have you hugged your backup today?

  5. #5
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Not a day doesn't go by where I don't learn something new

    So, how do the scrubs at M$ let that mistake out the f'n door
    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.

  6. #6
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    ooops...so much for an mvp
    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.

  7. #7
    Join Date
    Aug 2007
    Posts
    3
    That is exactly it. Thank you very much hmscott...really appreciate it. (now i can stop banging my head trying to figure it out, was really painful as i checked every possible thing (that i know of)).

  8. #8
    Join Date
    Dec 2002
    Posts
    1,245
    Quote Originally Posted by sbajaj
    That is exactly it. Thank you very much hmscott...really appreciate it. (now i can stop banging my head trying to figure it out, was really painful as i checked every possible thing (that i know of)).
    You're welcome. Nice to hear back when some of my advice actually turns out to be correct!



    Regards,

    hmscott
    Have you hugged your backup today?

  9. #9
    Join Date
    Dec 2002
    Posts
    1,245
    Quote Originally Posted by Brett Kaiser
    ooops...so much for an mvp

    S'alright. The Thought Police don't own the internet yet.

    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
  •