October 8, 2014 at 5:54 am
Hi,
Can any body suggest me the calculation used to configure sql server min and max memory settings as per the OS, RAM size and number of CPU
For example
I have SQL Server 2008r2 with 64-bit edition and OS windows Sever 2008r2 with 64 GB Ram, Logical CPU count:16 and physical CPU count:4
For this type of scenario what should be the SQL Server min and max memory settings.
Is the min and max memory settings depended on number of CPU (physical and logical) count.
What calculation method should I used to allocate memory to SQL Server
Thanks and Regards,
Nikhil P Desai
October 8, 2014 at 6:07 am
Chapter 4: http://www.red-gate.com/community/books/accidental-dba
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
October 15, 2014 at 9:01 am
On a server with >16GB, (64 GB in this example) we usually set Max Mem to (64 GB - 4 GB = 60 GB or 61440), and Min Mem to (Max Mem \ 2 = 30720). This would be if the only thing running on the server is SQL Database services. That leaves 4 GB for the OS and "other" processes running on the server like backups etc.
Memory is a terrible thing to waste.
October 15, 2014 at 10:10 am
That's a little on the high side. The OS needs memory to manage memory and it doesn't much like being starved.
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
October 15, 2014 at 11:09 am
Your mileage may vary.
October 16, 2014 at 6:18 pm
I whether right or wrong tend to reserver 10% OS when you get to around the 64GB mark. But i round up to the nearest 2GB. So a 64GB server i would set to 56GB for SQL, leaving 8GB for OS etc.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply