What does the following return? (exact output)
SELECT value_in_use FROM sys.configurations AS c WHERE name = 'max server memory (MB)'
What does the Total Server Memory perfmon counter show?
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