SQLServer查询所有数据库大小
with fs
as
(
select database_id, type, size * 8.0 / 1024 size
from sys.master_files
)
select
name,
(select cast(round(sum(size),2) as numeric(15,2)) from fs where type = 0 and fs.database_id = db.database_id) DataFileSizeMB,
(select cast(round(sum(size),2) as numeric(15,2)) from fs where type = 1 and fs.database_id = db.database_id) LogFileSizeMB
from sys.databases db
order by 2 desc;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/22996654/viewspace-2665036/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
SQLServer批量更新
下一篇：
MySQL子查询
请登录后发表评论
登录
全部评论
