madhu-686862 (10/22/2013)
So total 4 GB is used for both the instances out of 16 GB. So where is the rest of memory 12GB going?
That's what you're going to have to figure out. Look in Task manager (though note that it lies) and the memory-related counters in perfmon, including those in the process object.
What should be the Ideal or acceptable value for AvailableMbytes?
A few hundred at very least. More if you remote desktop into the machine
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability