Submit a ticketCall us

Training ClassThe Orion® Platform Instructor-led Classes

Provided by SolarWinds® Academy, these trainings will introduce users to the Orion Platform and its features, management, and navigation. These courses are suitable for users looking to discover new tips, tricks, and ways to adapt their Orion products to better suit their monitoring needs:
Deploying the Orion Platform
Configuring Orion views, maps, and accounts
Configuring Orion alerts and reports

Reserve your seat.

Home > Success Center > Netflow Traffic Analyzer (NTA) > NTA - Knowledgebase Articles > Remove old database tables from NTA

Remove old database tables from NTA

Table of contents

Updated January 19, 2017

Overview

This article explains how to remove old database tables from NTA.

Environment

All NTA versions

Steps

To remove the Netflow data previously collected by an earlier installation of the NTA module, you can run a truncate command on some of the NetFlow tables.

Note: All historical data will be lost by clearing these tables.

 

  1. Open the Orion Database Manager and connect to your SQL server.
  2. Expand the NetPerfMon table for your NPM server and right click the noted tables in Step 6 to select query table.
  3. Input the relative query command for each table listed into the white space, and delete the default select.. query.
  4. Verify that the Read-Write option is selected.
  5. Select Refresh to execute the truncate query command.
  6. Repeat for each of the following tables:
  • truncate table NetFlowSummary1
  • truncate table NetFlowSummary2
  • truncate table NetFlowSummary3
  • truncate table NetFlowDetail_### (where ### is relative to your table instance)
  • truncate table FlowCorrelation

After completing, run a shrink on the database using the Microsoft SQL Manager to clear the unused white space that was created with the truncation. See Microsoft Support documentation for these SQL server steps.

 

 

Last modified

Tags

Classifications

Public