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.
asked Feb 01 '10 at 08:12 AM in Default
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!
answered Feb 01 '10 at 08:19 AM
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.
answered Feb 01 '10 at 02:26 PM