Managing the size of the Alert Repository data files on disk

Every time an alert is raised, one or more alert files are created containing details about the alert. These alert files are stored on the same computer that runs the Alert Repository service.

When SQL Response has been running for several days or weeks, the number of alert files stored in the data store folder could grow to be quite large. This takes up a lot of disk space, and may adversely affect the performance of SQL Response.

To keep the disk space used at a manageable level, you can choose to automatically delete alert files older than a specified date:

1. From the Alert Repository menu in the SQL Response client, select Alert Repository Options.
2. Select Automatically delete old Alert Repository files and specify when to delete old files.

SQL Response checks every few minutes to remove any files that are older than the time you specify.