My server that SQL Server runs on has 8GB of Ram. Is there a standard formula that DBA use to gauge the minimum and maximum resource to be allocated for SQL Server base on the server Ram size?
I need to know how much of MB is optimal for these settings:
- Minimum Server Memory(MB)
- Maximum Server Memory(MB) and
- Minimum memory per query.
My research get me to this link:Guideline
But I think the best solution is to know how he get to those figures.