Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT total_physical_memory_kb/1024 AS [Physical Memory (MB)],
- available_physical_memory_kb/1024 AS [Available Memory (MB)],
- total_page_file_kb/1024 AS [Total Page File (MB)],
- available_page_file_kb/1024 AS [Available Page File (MB)],
- system_cache_kb/1024 AS [System Cache (MB)],
- system_memory_state_desc AS [System Memory State]
- FROM sys.dm_os_sys_memory WITH (NOLOCK) OPTION (RECOMPILE);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement