mah_j (4/13/2014)
Thank you for simplifying the calculation,so as he said if a server has 64 GB of RAM, and the Windows operating system is Windows Server 2008 64-bit Standard Edition, then the OS limit is 32 GB and that is the most that could be used by SQL Server.but if I use this calculation I come to the value of 54G for a 64G machine,is it different for above 32G?
That is explaining the OS max. Standard vs. Enterprise.
I had a server running Std, with 32 GB.
To see more memory (i.e. scale the server), I would have to more to Enterprise version of the OS.