Tuesday, February 2, 2016

Are you running low on server memory for SQL Server

 -- Are you running low on server memory for SQL Server?

SELECT available_physical_memory_kb/1024 as "Total Memory MB",
       available_physical_memory_kb/(total_physical_memory_kb*1.0)*100 AS "% Memory Free"
FROM sys.dm_os_sys_memory

No comments:

Post a Comment