DB용량 알아내는 쿼리 - MDF. LDF 파일 용량

select x.name, y.[SIZE(MB)] AS [DATA SIZE(MB)], x.[SIZE(MB)] AS [LOG SIZE(MB)]
from
(SELECT b.name ,CASE type_desc
WHEN 'ROWS' THEN 'DATA' ELSE type_desc END AS 'File Type' ,SUM(size*8)/1024. AS 'SIZE(MB)'
FROM sys.master_files a JOIN sys.sysdatabases b ON a.database_id= b.dbid
WHERE database_id>=7 and type_desc = 'LOG'
GROUP BY b.name,type_desc ) x

left outer join
(SELECT b.name ,CASE type_desc
WHEN 'ROWS' THEN 'DATA' ELSE type_desc END AS 'File Type' ,SUM(size*8)/1024. AS 'SIZE(MB)'
FROM sys.master_files a JOIN sys.sysdatabases b ON a.database_id= b.dbid
WHERE database_id>=7 and type_desc = 'ROWS'
GROUP BY b.name,type_desc ) y

on x.name = y.name

ORDER BY y.name