In Windows Server 2008 and greater, you can use the Resource Monitor to observe how SQL server utilises memory (accessable via Task manager)
Monitoring Resource Usage (System Monitor)
Effects of min and max server memory
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”