Configure Physical Memory

  • 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

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

  • 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

  • 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.

  • Hi,

    We are using 32bit sqlserver

  • Hi

    We are using 32bit sqlserver

  • 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

  • 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