Collector Database Maintenance

Use the Network Traffic Analysis Database Table Maintenance (SETTINGS menu > Network Traffic Analysis > NTA Record Maintenance) dialog to perform table maintenance on the Network Traffic Analysis database and archive database.

Regularly purging database tables can improve performance of Network Traffic Analysis.

Important: Purged data cannot be recovered. Make sure that you export and save any Flow data you need for your records.

Step 1: Stop the Ipswitch Flow Collector Service

To perform any of the purge actions listed in this dialog, you must first stop the Flow Collector service.

  1. From the Network Traffic Analysis Database Table Maintenance dialog (SETTINGS menu > Network Traffic Analysis > NTA Record Maintenance) , click on the Stop Service button.

    An alert box confirms the service shutdown.

  2. Click the Start Ipswitch NTA Collector upon completion checkbox.
  3. Enter a freshness period in days using the Delete log records older than text box.
  4. Select the category of database item(s) you want to purge.

Step 2: Select items to purge

When the Ipswitch Flow Collector service has been stopped, you can select the Network Traffic Analysis database tables you want to purge.

Step 3: (optional) Maintain log data during a purge

You can configure Network Traffic Analysis to keep a given number of days of log data during a purge of the Log table.

Enter the number of days of logs you want Network Traffic Analysis to maintain in Delete log records older than xx days. Log data that is older than the configured number of days will be purged from the Log table.

Step 4: Initiate the purge (and with immediate restart of collector service)

After you have selected or configured all of the appropriate database table maintenance tasks:

  1. Ensure Start Ipswitch Flow Collector service upon completion is checked (otherwise, you will need to restart the Flow Collector service from SETTINGS menu > System Services).
  2. Review your selections, then click Purge to begin database maintenance. The database maintenance process could be lengthy depending on the size of the tables in your Network Traffic Analysis database and archive database.

Important: Do not navigate away from this page or close the Web browser until the process finishes completely. Failure to wait on the process to complete may result in database corruption or data loss.

See Also

Network Traffic Analysis

NTA System Overview

NTA System Requirements

NTA Quick Start

Choosing NTA Sources

Configuring and Enabling Collection on Sources

Aggregating Sources

Grouping Traffic

Classifying Traffic by Port Number

Adding Custom Labels for Type of Service (ToS) IDs

Listener Port, Collection, and Retention Settings

Reduce and Analyze Traffic with Advanced Filtering