How much RAM should I allocate to SQL?
In 2021, if you are on standard edition, the answer is always 128GB, which is the max.
So how much RAM needs to be in the server to allocate 128GB to SQL? 147GB
The Best practices formula is:
T=total GB RAM in server
A=GB RAM that should be allocated to SQL server.
A = T - (1 + ((if(T>16) then 3 else (T-4)/4)) + (if(T<=16) then 0 else (T-16)/8))
If I want to figure out how much RAM I need in the machine to allocate a certain amount to SQL once above 16GB:
T=((A+2) * 8)/7
OK, so that is kind of complicated and RAM comes in limited increments. So I have generated the following table for the most common increments of RAM.
