SQl Server Max Memory usage
Posted on 2014-09-14
I am looking into a SQL Server's performance outputs and I see an inconsistency with the following metrics.
1. When I query the physical memory in use by SQL with the following query, I get '8342' in MB:
(physical_memory_in_use_kb/1024) AS Memory_usedby_MSSQL_MB,
2. The SQL Server memory usage max and min values are set to 8000 and 0 respectively. I verify that both from UI and following SQL query:
SELECT name, value, value_in_use, [description]
WHERE name like '%server memory%'
ORDER BY name OPTION (RECOMPILE);
3. I am not sure if the SQL Server Services are restarted after the memory max and min is set. I believe they are but I cannot be 100% sure.
My question is, how come the physical memory used is higher than the max value. (Usage 8342 and max set is only 8000) What will be my next steps to troubleshoot the issue?
Thank you in advance