Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

 

 

 

Home > Success Center > Netflow Traffic Analyzer (NTA) > Netflow database maintenance

Netflow database maintenance

Table of contents
Created by Aileen de Lara, last modified by MindTouch on Jun 23, 2016

Views: 1,610 Votes: 0 Revisions: 2

Overview

This article provides information on Netflow database maintenance. 

Environment

All NTA versions

Steps

Reasons for running this wizard:

  • Database Performance is slow.
  • Database File Group has unused space that needs to be reclaimed.
  • Stale resource data (IP Addresses that do not appear in current flows) needs to be removed from the Database.


Precautions:

  • Make sure you have a current SQL backup before running this wizard.
  • Make sure Orion services are stopped on all pollers.


1. Log into the Netflow server.
2. Open %Solarwinds Program Directory%\Orion\NetFlowTrafficAnalysis\.
3. Launch NetflowDatabaseMaintenance.exe.

Explanation of NetFlow Database Maintenance Options:

 

  • Shrink Database logs and Files (default: quick)

Each file within a database can be reduced to remove unused pages. Although the Database Engine will reuse space effectively, there are times when a file no longer needs to be as large as it once was; shrinking the file may then become necessary.

  • Delete expired flow data (default: 1000 IPs at a time, 15 min to process)

This option will remove any flow data for IPs not listed in current flows (30 days). The "note:" listed under this option will report how many expired IPs are currently present in the Database.

  • Re-Index NetFlow data tables (default: Quick)

When any data modification operations are run (INSERT, UPDATE, or DELETE statements) table fragmentation can occur. Re-indexing rebuilds the tables index (similar to a file system defragmentation) which can greatly improve performance.

After completing the Database Maintenance Wizard a log file will be generated in the same directory named: DatabaseMaintenance.log.

This file will list all actions committed by the wizard.

 

 

 

Last modified
20:35, 22 Jun 2016

Tags

Classifications

Public