Categories:

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 [Page File Commit Limit (MB)]
,available_page_file_kb / 1024 AS [Available Page File (MB)]
,(total_page_file_kb – total_physical_memory_kb) / 1024
AS [Physical Page File Size (MB)]
,system_cache_kb / 1024 AS [System Cache (MB)]
/* Values: LOW/HIGH/STEADY / ,system_memory_state_desc AS [System Memory State] FROM sys.dm_os_sys_memory WITH (NOLOCK); SELECT physical_memory_in_use_kb / 1024 AS [SQL Server Memory Usage (MB)] ,locked_page_allocations_kb / 1024 AS [SQL Server Locked Pages Allocation (MB)] ,large_page_allocations_kb / 1024 AS [SQL Server Large Pages Allocation (MB)] ,memory_utilization_percentage ,available_commit_limit_kb ,process_physical_memory_low / May indicate memory pressure */
,process_virtual_memory_low
FROM sys.dm_os_process_memory WITH (NOLOCK);

No responses yet

Bir cevap yazın

E-posta hesabınız yayımlanmayacak.