Q: How can I quickly see the total size of all the databases I have on Microsoft SQL Server?

Find out how large your databases are on SQL Server.

John Savill

January 1, 2012

1 Min Read
ITPro Today logo in a gray background | ITPro Today

A: The simplest way to see the total size of all databases on SQL Server is to run the sp_helpdb procedure. To do this, perform the following:

  1. Launch the SQL Server Management Studio (part of the SQL Server tools installation).

  2. Connect to your database server.

  3. Select the New Query button.

  4. Type the following:

    exec sp_helpdb

  5. Press the Execute button or just press F5.

  6. The database size of all your databases will be displayed in the results, as the screen shot shows below.

Get more help from John Savill on everything Microsoft--and more--at John Savill's FAQS for Windows.

About the Author

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like