Clearing Traps in Solarwinds

At times the Traps and TrapsVarBinds tables fill up for no useful reason in Solarwinds. The way to clear these down are as follows:

Clearing it Down
Start > All Programs > Solarwinds Orion > Advanced Features > Database Manager
Expand your database and right-click on the TrapVarbinds table.
Select Query Table.

Type the below SQL query:
TRUNCATE TABLE TrapVarbinds
Click on Refresh to execute the query.

This can take sometime to run depending on how many records are in your table

Once that is complete
Compact the Database
This can also take some time. This will reindex the tables, shrink the database and remove useless whitespace.

Keeping the Tables Small
Trap Retention
This lets you configure what to trap

Start > All Programs > Solarwinds Orion > Syslog and SNMP Traps > Trap Viewer
Click File > Settings

Modify the “Retain Traps in the database for ? days” setting in the general Tab.

Once that is done:
Make sure no servers are sending traps unless they need to
Get rid of unwanted rules