Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- database_name = DB_NAME(database_id)
- , log_size_mb = CAST(SUM(CASE WHEN type_desc = 'LOG' THEN SIZE END) * 8. / 1024 AS DECIMAL(8,2))
- , row_size_mb = CAST(SUM(CASE WHEN type_desc = 'ROWS' THEN SIZE END) * 8. / 1024 AS DECIMAL(8,2))
- , total_size_mb = CAST(SUM(SIZE) * 8. / 1024 AS DECIMAL(8,2))
- FROM sys.master_files WITH(NOWAIT)
- GROUP BY database_id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement