Submit a ticketCall us

AnnouncementsChange Is Inevitable

Get valuable help when it comes to tracking and monitoring changes. SolarWinds® Server Configuration Monitor (SCM) is designed to help you: detect, track, and receive alerts when changes occur, correlate system performance against configuration changes, compare server and application configuration against custom baselines, and verify application and system changes.

Learn more.

Home > Success Center > Network Performance Monitor (NPM) > NPM - Knowledgebase Articles > 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. This is also true for the Syslogs table. 

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 or Syslog:
    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