Post reply

Configure Physical Memory

  • July 13, 2010 at 7:10 am

    #143994

    Hi

    Iam having 32 GB of RAM, and i want to assign 25 GB of Physical Ram to SQlserver 2005.

    Can do like this,

    --By adding PAE switch and enabling the AWE in sql server

    &

    --Setting the max server in sqlserver..........

    Do the above configuriation will do the needfull.......if i go wrong please let me guide to configure the 25 GB of Ram out of 32 GB Ram.

    Koteswar Rao

  • July 13, 2010 at 8:32 am

    #1192068

    Do you have Windows and SQL Server 32 bit or 64 bit?

  • July 13, 2010 at 8:50 am

    #1192087

    As magasvs stated, a little bit more information is needed before suggestions or advice can be given.

    What OS edition and 32 or 64 bit?

    What SQL Edition (Enterprise, Standard, etc) and 32 or 64 bit?

    There are numerous post on SSC and MSDN that deal with memory settings on SQL Server. A major player in the decision making process is what OS version you are running and if 64-bit or 32-bit.

    If you are running Enterprise edition of OS and SQL on a 64-bit one of the main configuration settings you need to work on is the min and max memory settings for SQL Server. The AWE setting does not come into play on a 64-bit SQL instance. I would suggest utilizing Performance Monitor (perfmon) to find the happy medium on how much memory your instance of SQL is wanting and actually using.

    The memory usage can change over time depending on what type of application is running against SQL Server, so you should always review this information frequently.

    Shawn Melton
    Twitter: @wsmelton
    Blog: wsmelton.github.com
    Github: wsmelton

  • July 13, 2010 at 9:12 am

    #1192124

    If you use SQL Server 64 bit then you need to add "Lock pages in memory" permissions to the SQL Server Service Account using Group Policy tool.

  • July 13, 2010 at 11:20 am

    #1192243

    Hi,

    We are using 32bit sqlserver

  • July 13, 2010 at 11:21 am

    #1192246

    Hi

    We are using 32bit sqlserver

  • July 13, 2010 at 12:22 pm

    #1192267

    Hi Koteswara Rao,

    As it is a 32-bit machine, use

    1. PAE Switch -- On windows side

    2. AWE -- On SQL Server Side

    3. Max Memory Setting -- 25600 MB (25 GB) on SQL Server Side

    4. Use Lock pages in Memory (Optional)-- To prevent paging out SQL Server memory pages -- On windows side.

    On 64-Bit machine AWE is not needed.

    Thank You,

    Best Regards,

    SQL Buddy

  • July 14, 2010 at 1:45 am

    #1192608

    Hi,

    thanks alot for your reply...........

    koteswarrao

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

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