|
what consideration should be there to set memory for sql server 2005? if i have 14 GB of memory, what parameter should be taken care to set Max memory for instance. Please brief the solution.
(comments are locked)
|
|
I have two instance on a server with 20GB RAM and have set each instance to use no more than 9GB, therefore leaving 2GB for other applications and OS. The 9GB limit is often exceeded by each instance by a few MB but there is generally 1.5GB not used by SQL Server and this seems fine. I would not allocate <1GB for the OS, personally. This means that if everything else locks up, at least the OS will still be able to cope with me logging in to recover the server. In theory! Definate + 1. Around 2gb for the OS is a decent rule of thumb. As with all things, don't take it for granted, test, test test on your own system.
Feb 01 '10 at 10:14 AM
Grant Fritchey ♦♦
(comments are locked)
|
|
I am uisng x64 server and 16GB of memory so that I don't need to turn the AWE (Address Windowing Extensions ) on and it will only need it in 32bit version of SQL Server. I don't change any value of my SQL server and I left as it is. I used to have 32bit windows server and SQL 2008 32bit version, I have assigned to leaving 2GB left for Maximum Memory (for example ...16GB memory, Max Mem = 14GB). Also Here is the explanation of Brad McGehee From RedGate....
I hope it helps.
(comments are locked)
|

