Security Expert Database Table Sizes

[Alan_Wood]

Issue

Understanding the size of individual tables within the Security Expert databases is essential for effective database management. This insight helps optimize system performance and supports archiving strategies.

Product Line

EcoStruxure Security Expert

Environment

• EcoStruxure Security Expert
• Microsoft SQL Server

Cause

Managing SQL database size is critical to maintaining system performance. Identifying which tables consume the most space provides actionable data for optimization and archiving.

Resolution

To determine table sizes in the Security Expert and Security Expert Events databases, follow these steps using SQL Server Management Studio (SSMS):

1. Open SSMS
2. Right-click on the relevant database (e.g., Security Expert or Security Expert Events).
3. Navigate to:
   Reports > Standard Reports > Disk Usage by Table
   

   

4. Review the report to identify tables with the largest data footprint.

Examples:

• Security Expert DB

  

• Security Expert Events DB

  

Exporting the Report

You can print or export the report for documentation or analysis:

• Print
  

• Export to Excel, PDF or Word

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

     

Note: The “Disk Usage by Table” report is available in SQL Server 2008 and later.