Microsoft - Microsoft Anwendungen - SQL |
|
Autor: Marius El 2017-05-13 |
RAM Verwendung der SQL Instanz auslesen Version: |
Über ein SQL Statement im SQL Management Studio kann die aktuelle RAM Verwendung ausgelesen werden.
SELECT (physical_memory_in_use_kb/1024) AS Memory_usedby_Sqlserver_MB,
(locked_page_allocations_kb/1024) AS Locked_pages_used_Sqlserver_MB,
(total_virtual_address_space_kb/1024) AS Total_VAS_in_MB,
process_physical_memory_low,
process_virtual_memory_low FROM sys.dm_os_process_memory; |