Submit a ticketCall us

whitepaperYour VM Perplexities Called, and They Need You to Read This.

Virtualization can give you enormous flexibility with future workloads and can be a key enabler for other areas, like cloud computing and disaster recovery. So, how can you get a handle on the performance challenges in your virtual environment and manage deployments without erasing the potential upside? Learn the four key areas you need to be focusing on to help deliver a healthy and well-performing data center.

Get your free white paper.

Home > Success Center > Netflow Traffic Analyzer (NTA) > NTA - Knowledgebase Articles > Remove stale data from the Orion database after upgrading to NTA 4 and later versions

Remove stale data from the Orion database after upgrading to NTA 4 and later versions

Table of contents
Created by Michael Perez, last modified by MindTouch on Jun 23, 2016

Views: 821 Votes: 2 Revisions: 4

Overview

When upgrading to NTA 4 and later versions, Orion makes use of the FlowStorage Database and will not add new Netflow data in the Orion database. If you chose to retain the previous data during migration, this article will describe how to remove it after the migration.  

Environment

NTA 4 and later versions

Steps

  1. Take a full backup of the Orion database.  
  2. Run the following query against the Orion Database:
    --Start--
    UPDATE NetFlowGlobalSettings
    SET Value = 2
    WHERE Keyname = 'MigrateSqlFlows.MigrationOption'
    --End--
  3. Restart the Netflow service on the Orion server, followed by all additional polling engines.

 

When the Netflow service sees that the setting changed in the database, it will trigger the removal of the stale information from the Orion database. This will cause no changes on the FlowStorage Database.  

 

 

 

Last modified

Tags

Classifications

Public