MSSQL OS 메모리 사용량 확인

MSSQL OS 메모리 사용량 확인

select
total_physical_memory_kb/1024 as [total_physical_memory]       -- OS 물리적메모리크기
,available_physical_memory_kb/1024 as [available_physical_memory] -- OS 사용가능한메모리크기
,(available_physical_memory_kb/1024*100)/(total_physical_memory_kb/1024)   as [available_physical_memory_percent] -- OS 사용가능한 메모리 퍼센트
,total_page_file_kb/1024  as [total_page_file]      -- OS 전체페이지파일(가상 메모리)
,available_page_file_kb/1024  as [available_page_file]    -- OS 사용가능한페이지파일(가상 메모리)
,(available_page_file_kb/1024*100)/(total_page_file_kb/1024)   as [available_page_file_percent] -- OS 사용가능한페이지파일 퍼센트
,system_memory_state_desc        -- 시스템메모리상태
from sys.dm_os_sys_memory

.