How much memory does my SQL server really need? Sounds like an easy question right? When you look at the minimum recommendations from Microsoft regarding SQL 2012 it states the following.
Processor, Memory, and Operating System Requirements
The following memory and processor requirements apply to all editions of SQL Server
Express Editions: 512 MB, All other editions: 1 GB
Express Edition: 1 GB All other editions: At least 4 GB and should be increased as database size increases to ensure optimal performance.
Microsoft is recommending at least 4 Gigs of RAM for SQL 2012. In addition, that we should add more memory as the database size increases. However it is not clear how much memory we should add as the database grows.
For example, lets say you have a database on a default SQL instance that is 100GB in size and the server has 2 x CPU at 3.30 GHz Quad core Win 2008 R2 Standard edition. This is a dedicated physical SQL server which will be supporting 1000 clients. However, lets also take into consideration that not all 1000 clients will be using this SQL server all at the same time everyday.
Lets also say that the database in question is in pristine condition and the DB growth rate is expected to be 1GB a month. In addition that the the TempDB is setup with additional secondary data files to reflect the CPU core count.
Here is my question, would you configure your SQL server with only
the min memory recommended by Microsoft? If no, how much memory would you give this SQL database and why?