Still think i'm being misunderstood, the memory allocated is 24GB this is fine and as expected as its the Max Server Memory...
The problem is that 75% of that 'allocated' memory is constantly being used i.e. 18GB is in use now by sql server, even though nothing is running. If you look at perfmon logs the sql memory in use never drops on this server..
Server 32GB
SQL Allocated 24GB
SQL In Use 18GB ??
OS is not using more than a couple ever, and it has 8GB to itself anyhow...
Oraculum