How to identify large tables in database

Owned by Knowledge Assistant
Last updated: Dec 21, 2023
1 min read



Description of Issue

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



Context

  • Database

  • SQL Server Management Studio (SSMS)



Cause

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



Resolution

  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



Additional Information

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