November 5, 2008 at 10:59 am
We're running SQL 2008 DE on a test server with 16 GB of ram. The OS is Win2003 Server EE, 32 bit. AWE is enabled. Nothing else is running on the machine. What is the best configuration for min and max memory setting? Right now min is set to 0 and max is set to 13000.
November 5, 2008 at 12:00 pm
That's a good config you have there. You could probably bump the max to 14 if there's nothing running on the server.
I seldom bother setting the min in SQL 2005 and higher. The minimum isn't the amount that SQL will take as it starts up, just the value that it will not drop below once it has been reached. If there's nothing else on the server, there's no reason SQL would be forced to reduce memory usage.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply