Menu

Want to work with us? We're on the lookout for digital experts.

We're hiring

SQL Server Database Size Ordered by Size

Web Bureau


03 September 2014 by Web Bureau

Get the database sizes for all databases on a SQL Server Instance

 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)
--WHERE database_id = DB_ID() -- for current db
GROUP BY database_id
order by CAST(SUM(size) * 8. / 1024 AS DECIMAL(8,2)) desc

REF: http://stackoverflow.com/a/18014581

Grow your businessStart a project with us today.

This site uses essential cookies for parts of the site to operate and have already been set. Find out more about how we use cookies and how you may delete them. You may delete cookies, but parts of the site will not work.