February 25, 2009 at 11:41 am
What's the default RAM setting on 4G memory server after install SQL 2005. I see 2G for SQL server and 2G left for Windows 2008 OS. This is 64 bit env for SQL and OS.
February 25, 2009 at 2:48 pm
Hmm, I thought it was set to auto manage by default..
February 25, 2009 at 3:25 pm
The default max memory setting after install is 2TB, regardless of the amount of memory available on the server.
On x64 platforms - you want to always set the maximum to something less than the maximum available. With 4GB available on the server - I would set the maximum to no more than 3072 MB, leaving 1GB for the OS.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply