Troubleshooting Server Database Size

The Endpoint Sensor server uses a database to store its records. By default, the database grows in size as it records more information. However, the database may be configured to limit itself to a fixed size. To change the server database size, perform the following procedure:

Note:

Before performing the following steps, Trend Micro recommends creating a back up of the Endpoint Sensor SQL database using your preferred SQL application.

  1. Open an application that can send a query statement to the SQL server.
  2. Connect to the Endpoint Sensor SQL database, and send the following commands:

    • To turn the auto-purge feature on:

    UPDATE dbo.Setting set Value = CAST('1' as varbinary) 
WHERE Category='/TMSL/SQLServer/' AND [Key]='CheckDBSize'
UPDATE dbo.Setting set Value = CAST('<value>' as varbinary) 
WHERE Category='/TMSL/SQLServer/' AND [Key]='DBSizeLimitMB'

    • To turn the auto-purge feature off:

    UPDATE dbo.Setting set Value = CAST('0' as varbinary) 
WHERE Category='/TMSL/SQLServer/' AND [Key]='CheckDBSize'
    Note:

    Set <value> to the preferred maximum size of the database in MB.

  3. The database resizes when the next investigation is triggered. Server performance may be affected while the database is resizing. Performance returns to normal once the database has been set to the specified size.
Note:

To manage the database size of Endpoint Sensor agents, use the Endpoints screen.

For details, Endpoint.