1. Home
  2. Cloud & Dedicated Servers
  3. MS SQL
  4. How to View a Report of MS SQL Database Disk Usage

How to View a Report of MS SQL Database Disk Usage

How to View a Report of SQL Database Disk Usage

 

First, remotely connect to your database by logging in to the database server using SQL Management Studio.

A separate KB is available here that covers connecting to your database if needed needed:
http://support.appliedi.net/index.php?/Knowledgebase/Article/View/458/84/how-to-login-to-your-ms-sql-server-through-sql-server-managment-studio-express

 

Once logged in, simply right-click on your database name, go to the ‘Reports‘ area, and under ‘Standard Reports‘ you’ll see several options.  For checking which tables are using the most disk space, select the report ‘Disk Usage by Top Tables‘.  

 

Disk Usage Report

 

 

This will provide a sorted report by table disk usage such as in this example:

 

Disk Usage Report by Top Tables

Content retrieved from: https://support.appliedi.net/kb/a1012/how-to-view-a-report-of-ms-sql-database-disk-usage.aspx.

Updated on November 11, 2019

Was this article helpful?

Related Articles

Need Support?
Can't find the answer you're looking for? Don't worry we're here to help!
CONTACT SUPPORT

Leave a Comment