Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > Network Performance Monitor (NPM) > Truncate Traps and TrapVarbinds

Truncate Traps and TrapVarbinds

Table of contents

Updated April 28th, 2016

Overview

If the database is filling up and you find out that Traps and TrapVarbinds is causing it, see the steps below to truncate Traps and TrapVarbinds.

Environment

  • NPM 11.5.2
  • NPM 11.5.3

Steps

  1. Stop the Orion Services:
    1. Go to Start > All Programs > Solarwinds Orion > Advanced Features > Orion Service Manager.
    2. File > Stop Everything.
    3. Ensure the database service is still running.
  2. Truncate the table Traps and TrapVarbinds:
    1. Go to Start > All Programs > Solarwinds Orion > Database Utilities > Database Manager.
    2. If you do not see your database, you will need to add it.
    3. Expand your database, right-click on the table Traps and TrapVarbinds.
    4. Clear the default SQL query and type the below one:
      truncate table TRAPS
      truncate table TRAPVARBINDS
    5. Click Refresh to execute it.
  3. Start the Orion Server with Orion Service Manager.
  4. Go to Start > Everything.

 

Last modified

Tags

Classifications

Public