I am building a new virtual server - Windows 2008 R2 DataCenter.
Installed SQL Server 2008 R2 Standard Edition - 64 bit.
The "Maximum server memory" is set to 4096 MB
The server is having 6GB RAM.
Why is SQL server crossing the threshold memory and utilizing most of the available 6GB RAM.
With no other client connection yet and in idle server condition, currently I have got only 400 MB available.
Why is it eating up most memory?