Memory Setting with 64BIT

  • I have a 64BIT W2K3 Standard Edition Operating System with a 64BIT SQL Server Standard - 9.00.4035.00 (X64).

    It has 8GB of RAM. I've set the SQL Maximum Server Memory to 6144MB.

    What should I set the SQL Minimum Server Memory setting to?

    What is Best Practice in this regards?

    ..thanks

  • Hi

    You should allow the following:

    a. 2 GB for Windows

    b. xGB for SQL Server worker threads (http://www.coeo.com/presentations/Coeo_SQL_Memory.pdf)

    c. 1GB for multi-page allocations, linked servers, and other consumers of memory outside the buffer pool

    d. 1-3 GB for other application like backup program

    physical server RAM - sum(a,b,c,d) = MAX Server Memory

    Best regards,

    Michal Marek

    Best regards,
    Michał Marek

  • Thanks for the feedback, Michal.

    What about the MINIMUM Memory Setting?

    Should it be left at ZERO or set to match my MAXIMUM setting, or... ?

  • In my servers I set half of MAX SQL Server Memory.

    When you set "lock pages in memory" (usually set with "AWE" on 32 bit machines) in gpedit.msc, MIN Server memory is "locked" and Windows OS can't take it.

    Best regards,

    Michal Marek

    Best regards,
    Michał Marek

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

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