Post reply

Max Amount of RAM(Memory) the SQL server 2000 can use?

  • January 19, 2010 at 6:40 am

    #1105379

    ........

    note that once you turn on awe dynamic memory does not work - doesn't matter what you set in memory, awe will take the amount of memory you set as max memory.- so this setting is important

    .....

    SSCrazy, I found this quote from an earlier post you had:

    http://www.sqlservercentral.com/Forums/Topic407623-65-1.aspx

    So it appears that I'll need to slide the "Dynamically configured SQL Server Memory" over to use around 31GB of the 32GB avaliable, Is that correct? Otherwise it still going to use the 15GB?

    First thanks for your time in answers question on this site.

  • January 19, 2010 at 7:08 am

    #1105394

    thanks.

    that quote refers to SQL2000, in 2005 SQL can use AWe memory dynamically.

    so yes slide the bar over, but I would not go above 30GB, you risk starving the OS and whatever else is on the server.

    SQL will then take the memory if it wants it, no need to restart.

    ---------------------------------------------------------------------

  • January 19, 2010 at 7:22 pm

    #1105792

    Thanks to all who replied.

    I move the bar over on the SQL properties page, but nothing happened.

    I had to fail the cluster over to the stand by server and all it good.

Viewing 3 posts - 16 through 17 (of 17 total)

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