Hi,
NPM TrapVarBinds table in my NPM hits 32 GB size.
Please, how could I remove all data from this table ?
I don´t want delete this table, only your data.
In my environment we need SNMPtraps enabled.
thanks.
Without the trapvarbinds data, all snmp events will have no data.
They don't convert the trap to text and store it in one string, they store it in the way one should for a relational database by using indexes and multiple tables. If you truncate the varbinds, you should truncate the main trap table.
Check out this and this. You should setup some drops for unneeded traps, something is probably being very verbose and you don't need all the traps it is sending. This one is about syslogs, but the principles byrona talked about apply to rules for traps too.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.