Consumo MB por Base

Atenção: A consulta deve ser apontada para a base desejada.

WITH Consumo_Pool_Buffer
AS
(
                SELECT
                                Database_id,
                                BuffersPorPagina = COUNT_BIG(*)
                FROM sys.dm_os_buffer_descriptors
                GROUP BY database_id
)
SELECT
                Database_id as DatabaseID,
                CASE Database_id WHEN 32767
                                THEN 'Recurso interno do SQL SERVER'
                                ELSE DB_NAME(Database_id) END AS DatabaseName,
                BuffersPorPagina,
                (CONVERT(NUMERIC(10,2),BuffersPorPagina*8)/1024) AS BuffersPorMB
FROM Consumo_Pool_Buffer
ORDER BY BuffersPorPagina DESC, BuffersPorMB DESC
GO