Post reply

SQL Minimum memory setting

  • November 23, 2007 at 2:50 am

    #119221

    Hello,

    I have the following server:

    Windows 2003 enterprise sp1

    16GB RAM

    SQL Server 2000 Enterprise SP4

    I am trying to allocate 3800mb of RAM to SQL server and am receiving the error "Warning: unable to allocate 'min server memory' of 3800mb".

    The PAE and /3gb switches are enable in the boot.ini file.

    Do I need to enable AWE in SQL server or is there another issue.

    Thanks

    Andy

  • November 23, 2007 at 5:11 am

    #753605

    Hi,

    Yes you have to enable AWE.

    Check the links

    http://www.sql-server-performance.com/articles/per/awe_memory_sql2000_p1.aspx

    http://msdn2.microsoft.com/en-us/library/ms178067.aspx

    Regards,

    Ahmed

  • November 23, 2007 at 7:42 pm

    #753723

    You must also configure in the local security policy for the service account SQL Server is running under to have the right Lock pages in memory.

    SQL Server only uses 2 GB of memory even though the AWE option is enabled (811891)

    also

    How to configure SQL Server to use more than 2 GB of physical memory[/url]

    K. Brian Kelley
    @kbriankelley

  • December 4, 2007 at 7:36 pm

    #757198

    hi all, i hv some question... my memory setting for Microsoft sql server 2005 is set max at 256MB.. my database is 14gig. should i set at 2014MB at max setting in in sql server? tq

    pentium 4 2.8Ghz

    3 gig mem

  • December 5, 2007 at 1:17 am

    #757238

    Hello.

    You need to set the memory to be dynamically managed by SQL server. In management studio right click the server and select "properties", click the memory page and on the right pane click "Dynamic memory configuration". This will let SQL server manage the memory it uses. 256mb really isn't enough.

    regards

    Andy

  • December 7, 2007 at 2:46 am

    #757990

    :P:)

  • December 8, 2007 at 4:18 am

    #758282

    if you enable awe it disables dynamic memory allocation so the only setting which is important is the max memory settings ( 32 bit versions ) There's a KB somewhere which explains this - I'm still amazed that posts concerning memory appear constantly - maybe we could get Steve to put a permanent link on the home page to memory allocation?

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

Viewing 7 posts - 1 through 6 (of 6 total)

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