SqlServer内存占用查看

SELECT SUM(single_pages_kb)+SUM(MULTI_PAGES_KB) FROM
(
    SELECT 
        SUM(single_pages_kb) AS single_pages_kb
        ,SUM(MULTI_PAGES_KB) AS MULTI_PAGES_KB        
    FROM SYS.dm_os_memory_clerks
    GROUP BY [TYPE]

    
) AS A 
UNION
SELECT COUNT(ROW_COUNT) * 8.0 FROM SYS.dm_os_buffer_descriptors

SqlServer内存占用查看

标签：pre   nio   nbsp   page   count   sele   db_name   cas   clerk