Post reply

sql 2005 not grabing enough memory

  • January 31, 2013 at 8:14 pm

    #288406

    Hi

    I have sql 2005 standard edition on windows server 2003. AWE enabled with min set to 2.5gb and max set to 5gb. I can't seem to get the AWE allocated memory to reach 2.5gb.

  • February 1, 2013 at 12:17 am

    #1583281

    jdbrown239 (1/31/2013)

    I have sql 2005 standard edition on windows server 2003.

    are you using 32 bit server ?

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • February 1, 2013 at 1:39 am

    #1583299

    How are you checking memory usage?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 1, 2013 at 6:12 am

    #1583407

    Also know that the min server memory option does not force SQL Server to instantly allocate the amount of memory specified by the setting. After it has allocated that amount of memory the setting tells SQL Server not to automatically release memory as not to drop below that level.

    If your SQL Server is not being fully utilized or is not hosting a lot of data it may never even allocate the amount you specified for min server memory while happily handling all requests.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • February 1, 2013 at 10:52 am

    #1583519

    I am checking the memory with the standard memory consumption report and the server is 32bit.

Viewing 5 posts - 1 through 4 (of 4 total)

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