June 2, 2015 at 3:53 pm
I am purchasing a new server with Windows Server 2012R2 Standard and SQL Server Standard 2014. The current planned configuration of the server is to have one Xeon E5-2430 2.5 GHz 6-Core processor.
I know the minimum memory requirement for SQL2014 is 4GB. Obviously, I don't want to get the minimum. This Dell server will hold 12 slots of 16GB RDIMMs for a maximum of 384GB.
My question is how much memory should I get?
What say you? 32GB 64GB? More?
Thanks for the opinions, sages of SQL!
tcall
June 2, 2015 at 4:10 pm
The max memory that you could use with standard edition is 128GB. Go with max, if you can allow it.
Igor Micev,My blog: www.igormicev.com
June 2, 2015 at 4:30 pm
Thanks, Igor.
I see now too that the there's a maximum of 6 RDIMMs per processor. So, with 1 processor it looks like I'm maxed out at 96 GB.
tcall
June 4, 2015 at 7:28 am
The more memory the better. However, it is a 'it depends'. If you have one very small database planned for this SQL Server 96gig of memory is WAY overkill as it will never utilize it. If you have 10+ databases that are goodly sized and heavy activity then the more memory you have the better.
June 8, 2015 at 4:42 am
Hi,
It really does depend.
What is the server being used for. You may find disk is more important that memory.
A SQL Server configuration can very enormously depending on it's requirements of disk, memory and cpu. And one size will definitely not fit all.
Thanks
June 9, 2015 at 11:15 am
Markus (6/4/2015)
The more memory the better. However, it is a 'it depends'. If you have one very small database planned for this SQL Server 96gig of memory is WAY overkill as it will never utilize it. If you have 10+ databases that are goodly sized and heavy activity then the more memory you have the better.
I second this. you really only need as much memory as the size of your database(max), this way the entire database can be cached in memory. There is extra memory used outside of buffer pool but I believe that is negligible when talking about this amount of memory.
using Markus' example, if you have 10 databases, each being 10GB, and no expected growth, then the max memory you could expect to use is approx 100GB.
If you are upgrading from an existing server, monitor how much memory is used on it, estimate growth(both data and usage), and size your new server accordingly. as am example, I have a SQL server that hosts a 60GB database, has 17GB out of 24GB allocated to SQL server, and only regularly uses about 10GB of that 17GB. If I was to replace this server, there would be no need to increase memory as it would not be used.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply