SQL Server: Get All Databases Size


To get recent size of all databases on an instance, I have found following simple query very useful. 
SELECT  d.name,
       ROUND(SUM(mf.size) * 8 / 1024, 0) Size_MBs
FROM    sys.master_files mf
       INNER JOIN sys.databases d ON d.database_id = mf.database_id
WHERE   d.database_id> 4 — Skip systemdatabases
GROUP BY d.name
ORDER BY d.name
Advertisements

Posted on January 10, 2012, in Sql Server 2005, Sql Server 2008, SQL Server 2012, TSQL Tips n Tricks. Bookmark the permalink. 1 Comment.

  1. In my SQLS2005 I had to cut off "(MBs)" and then it worked. Thanks

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: