GilaMonster (9/26/2013)
There's no memory 'assigned' to the OS. 8GB is what SQL is leaving for the OS and any other app running on that server. That's rather a high figure for max server memory for that much memory.
Ok.
It was written in this book that "
As a general base configuration, for a dedicated SQL Server machine, reserve 1 GB of RAM
for the OS, 1 GB for each 4 GB of RAM installed from 4–16 GB, and then 1 GB for every 8
GB RAM installed above 16 GB RAM. This means that, for a server with 64 GB RAM, the
starting point for max server memory should be in the 54 GB range, and then tuned
higher based on monitoring the Memory\Available Mbytes performance counter."
Gail, please correct me if I'm wrong-- I'm thinking the max SQL server memory setting would be 250GB.