Purging Monitoring Tables

It may be necessary to purge the Submitted for Analysis and Monitoring Log tables to improve server performance. To purge the Submitted for Analysis and Monitoring Log tables, perform the following procedure:

  1. Install SQL Server Management Studio.
  2. Open SQL Server Management Studio, locate and connect to the Endpoint Sensor database SMARTSENSOR.
  3. Open Programmability > Stored Procedures.
  4. Locate and right-click the following items. For each item, click Execute Stored Procedure.... On the screen that appears, update the values according to your preference.
    Table 1.
    Stored Procedure Description
    dbo.SP_IRB_DeleteInspectedReportByDay

    Stored procedure purges reports n days before today.

    dbo.SP_IRB_DeleteInspectedReportByNumber

    Stored procedure purges n oldest reports.

  5. After updating each item, press Enter, or click OK to run the stored procedure.