诺诺在学习

原创 sqlserver-性能相关查询语句

1.查询sqlserver各对应数据库内存使用情况 select count(*)*8/1024 as 'cache size(MB)', case database_id when 32767 then 'ResourceDb' else DB_NAME(database_id) end as 'datebase' from sys.dm_os_buffer_descriptors group...