Security Expert Database Table Sizes

[Alan_Wood]

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.

1. Open SMSS
2. Right-click on the database the report is needed (i.e. Security Expert or Security Expert Events)
3. Select Reports> Standard Reports> Disk Usage by Table

   

4. 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

  1. Print
     

• Export to Excel, PDF or Word

  1. Right-click on the data results and select Export

     

Note: The disk usage built-in report was implemented in SQL 2008 and above.