Database - Trapvarbinds

Hey guys,

Has anyone noticed their size of their TrapVarbinds database? I was shocked to see mine is at 142GB!! i was reading the release notes for Orion 8.5.1 and it shows that the TrabVarBinds table gets deleted after 7days. Does this mean Orion no longer uses this table and i can safely remove it?

Thanks.

1.jpg

Find more posts tagged with

database_trapvarbinds

Accepted answers

All comments

mark_wiggans

The steps to truncate the trapvarbinds table can be found here

kulastone

wouldnt it be just easier to delete that table instead of truncating it? Does the db need this table?

mark_wiggans

If you are not using traps at all then you can turn them off to prevent the size of this table growing. I wonder if you still have some orphaned data from a previous version? This should be getting groomed as noted from the release notes.

The DB does need this table,the varbinds table contains the variable information defined within the trap. You should use the Truncate command. The Delete table command is a logged operation, so the deletion of which row gets logged into the transaction log, which uses more resources & makes it slow. The Truncate command deletes all the rows in the table without logging, instead it logs the de-allocation of the data pages, which makes it faster. It also perserves the table structure and it's columns, constraints, indexes, etc..

whitejcdc

Yeah, I don't think the 8.5 release fix works, since I'm using 9.5.1 and that table has grown to 39Gb. I would hope that in the releases following mine it has been fixed. I may try to upgrade and see.