How to identify large tables in database

Database is growing quickly and there is a need to identify what the cause is.

• Database

• SQL Server Management Studio (SSMS)

Though causes can vary, exponential growth could be due to a System Log table filling with multiple error/log messages daily.

1. Log into the database server

2. Open SSMS (SQL Server Management Studio)

3. Connect to the applicable instance

4. Expand Databases by clicking on the plus symbol (+)

5. Right-click on database

6. Navigate to Reports > Standard Reports > Disk Usage by Top Tables

Please create a case with TSM Support for further assistance in the Support Portal.