Skip to content

Instantly share code, notes, and snippets.

@richardbasile

richardbasile/memory.sql

Created February 16, 2018 13:58
Show Gist options
  • Save richardbasile/f74802fe71e3798b051afb252c952083 to your computer and use it in GitHub Desktop.
Save richardbasile/f74802fe71e3798b051afb252c952083 to your computer and use it in GitHub Desktop.
Download ZIP
SQL Server - Physical Memory
Raw
memory.sql
SELECT total_physical_memory_kb/1024 as "Physical Memory MB"
, available_physical_memory_kb/1024 as "Available Memory MB"
, available_physical_memory_kb/(total_physical_memory_kb*1.0)*100 AS "% Memory Free"
FROM sys.dm_os_sys_memory
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment