sqlserver 数据库内存占比查询
SELECT ISNULL(DB_NAME(DATABASE_ID),'RESOURCEDB') AS DATABASENAME, CAST(COUNT(ROW_COUNT) * 8.0 /(1024.0) AS DECIMAL(28,2)) AS 'SIZE(MB)' FROM SYS.dm_os_buffer_descriptors GROUP BY database_id ORDER BY DATABASENAME
有时候不是我们失去了目标,而是失去了方向。