May 26, 2009 at 5:16 am
Hello Everyone,
We upgraded our SQL production servers memory from 8GB to 16GB last week and that server is Win2003 Server installed. I look at the SQL server properties this morning and I saw something a bit strange... Dynamic Memory section Min Memory is set from 10 MB to Max Mem is 4GB even we have 16GB on the Server. Is that better to change it up to 16GB for Max Memory?
Also performance wise...I don't get best performance over upgrading memory, anything else I need to look at?
I use RAID 0 for all my DB .MDF and .LDF.
Thanks.
May 26, 2009 at 5:20 am
Leo (5/26/2009)
Is that better to change it up to 16GB for Max Memory?
Absolutely not. If you do that, SQL will try and take all 16 GB and it may starve the OS of memory. You'll get some very interesting error messages and possibly even a server crash.
With 16GB memory, set SQL's max memory to around 12GB-13GB. No more than 14. The OS needs memory to manage memory and the more memory in the server, the more the OS needs.
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
May 26, 2009 at 6:05 am
Also performance wise...I don't get best performance over upgrading memory, anything else I need to look at?
Increasing RAM alone does not boost performance for your systems, There are various factors that contribute towards the system performance 🙂
May 26, 2009 at 6:57 am
If this is a 32bit version of Windows have you also enabled PAE and AWE?
May 26, 2009 at 11:13 am
When looking at the dynamic setting - does it show that you can set it to 16GB? What is the SQL Server version you are running - Standard or Enterprise? If Standard, you are not going to be able to able to modify it since that version can only ever use 2GB of memory anyways.
Jeffrey Williams
Problems are opportunities brilliantly disguised as insurmountable obstacles.
How to post questions to get better answers faster
Managing Transaction Logs
May 27, 2009 at 1:52 am
Hi Jeffrey,
Yes, it said 16GB and Enterprise Version (SQL 2000).
Thanks.
May 27, 2009 at 8:21 am
Okay, then I would go with Gail's recommendation of 12GB max memory. You don't want to go higher than that, well maybe 13GB would be okay - but, you'll have to watch it to make sure.
Jeffrey Williams
Problems are opportunities brilliantly disguised as insurmountable obstacles.
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply