Could you clarify the Maximum Server Memory formula?
My VM's for sql server run with a minimum of 48gb.
If I follow your recommendation, I would be taking 9gb away from sql server.
Usually I reserve 4-5gb for the OS.
Also, using your recommendation for my one server that has 96gb, I would need to reserve 15gb for the OS.
Why?
Bill Soranno
MCP, MCTS, MCITP DBA
Database Administrator
Winona State University
Maxwell 143
"Quality, like Success, is a Journey, not a Destination" - William Soranno '92