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 > Network Performance Monitor (NPM) > Data retention for NetPath

Data retention for NetPath

Created by Anthony.Rinaldi, last modified by MindTouch on Jun 23, 2016

Views: 1,007 Votes: 0 Revisions: 2

Updated June 14, 2016

Overview

Orion uses SQL Server to collect data from network paths while probing. The database also contains configuration information for services and probes that collect the information.

By default, Orion retains NetPath data for 30 days. To change this value, see Edit the retention period below.

Environment

  • NPM 12.0 and later

Detail

The amount of data collected and stored by NetPath can add significant storage pressure on SQL Server. You should select an appropriate retention period and probing intervals related to the size of your database storage. See NetPath requirements for more information.

Edit the retention period

You cannot change the retention period through the Orion interface. You must edit the dbo.Settings table in the SQL Server database.

SettingsID Description
NetPath-Settings-Retain NetPath Detail The number of days data is retained in the database for the Performances, Tests, and Traces data. Care should be taken when increasing this value as it will add additional storage constraints on the database. The default value is 30 days.
NetPath-Settings-NetPath Orphan Batch The time interval in minutes to use for each batch when deleting orphan data. Care should be taken when increasing this value as it will increase the likely hood of locking on the NetPath tables. The default value is 1 hour.

 

 

 

Last modified
22:06, 22 Jun 2016

Tags

Classifications

Public