We have built a new 2 CPU, 6 core server, with 96GB of RAM. SQL server Enterprise Edition was configured with a maximum memory setting of 92GB.
A few days after adding into the load balancer I have noticed that perfmon says that only between 45-46GB of memory is being used.
SQL server reports it can see 98GB of ram on the server and windows is reporting 98GB of RAM in the server. The figure is suspiciously close to half the RAM though and task manager on the server normally reports the maximum memory setting configured in SQL server when running.
Any suggestions ?