madhu-686862 (10/22/2013)
Is there available memory for SQL to allocate?
8 GB Max Memory is configured for INS1 but it is taking only 3 GB. That means it has 5 GB available right?
No.
I asked, is there available memory for SQL to take, not how much of the configured max server memory has it used.
I can configure SQL with a max server memory of 20GB on my desktop and it will only take at most 10. That doesn't mean there's 10GB available. There will be none available as the machine has only 16 GB and other applications use up to 6GB.
So, is there available memory for SQL Server to allocate?
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