Issue
Identifying table sizes is useful when managing Security Expert databases
Product Line
EcoStruxure Security Expert
Environment
- EcoStruxure Security Expert
- Microsoft SQL Server
Cause
Managing the size of a SQL database is crucial to system performance and archiving so understanding which tables are the largest provides needed data
Resolution
A report can be run from SQL Server Management Studio(SMSS) on the Security Expert and Security Expert Events databases to provide table sizes.
- Open SMSS
- Right-click on the database the report is needed (i.e. Security Expert or Security Expert Events)
- Select Reports> Standard Reports> Disk Usage by Table
-
Scroll through and observe which tables contain the most data
Examples:
- Security Expert DB
-
Security Expert Events DB
-
Print or Export the report to a file if necessary
-
Print
-
-
Export to Excel, PDF or Word
-
Right-click on the data results and select Export
-
Note: The disk usage built-in report was implemented in SQL 2008 and above.
