查询数据库在数据缓存中占用的空间大小

 

1 SELECT COUNT(*)*8/1024 AS 'Cached Size(MB)',
2     CASE database_id WHEN 32767 THEN 'ResourceDb'
3     ELSE DB_NAME(database_id)
4     END AS 'Database'
5 FROM sys.dm_os_buffer_descriptors
6 GROUP BY DB_NAME(database_id), database_id
7 ORDER BY 'Cached Size(MB)' DESC

 

posted @ 2017-05-23 10:56  菡萏No.1  阅读(568)  评论(0)  编辑  收藏  举报