October 11, 2010 at 2:20 pm
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
October 12, 2010 at 2:06 am
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
October 12, 2010 at 6:41 am
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... ?
October 12, 2010 at 6:56 am
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