Submit a ticketCall us

AnnouncementsWeb Help Desk Integrations eCourse

Looking to reduce response times? Sign up for our eCourse to learn how integrating Web Help Desk with Dameware Remote Support, Network Configuration Manager, Network Performance Monitor, and Server & Application Monitor can improve communication efficiencies.

Register here.

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.X
  • NPM 12.X

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 Syslog
      Truncate Table Traps
      Truncate Table TrapVarBinds
    5. Click Refresh to execute it.
  3. *optionally - Run the Solarwinds Database Maintenance ,
    1. Click Start > All Programs > SolarWinds Orion > Advanced Features > Database Maintenance.
    2. Click Start.
    3. ref: 
      https://support.solarwinds.com/Succe...nance_manually
  4. Start the Orion Server with Orion Service Manager.
  5. Go to Start > Everything.

 

Last modified

Tags

Classifications

Public