Hi,
Last 3 days my SW Nightly database maintenance stays stucked in step below:
SolarWinds.Data.DatabaseMaintenance.MaintenanceEngine - Removing older data from Traps
What can I do to fix this issue ?
Thanks
maybe there isn't enough space in tempdb to drop the table. Like the day/days it's trying to drop contains a lot of data and it won't do it. you could either truncate the tables (if you don't care about the data), increase the size of tempdb, or manually clear smaller parts of the table. (of course that's all assuming that it is the size/amount of records that are being dropped.)
Oh, to drop them use:
TRUNCATE TABLE TrapVarbindsTRUNCATE TABLE Traps
To manually grab specific ones, you can use:
Delete from Traps Where datetime <= '4/1/2010'Delete from TrapVarBinds where TrapID not in (select TrapID from Traps)
I took some of this from here, but you might want to look at creating trap rules like this (he's talking about syslog, but same principles apply)
I´m afraid to issue truncate commands, I´m not a SQL expert.
Is there any danger doing these commands ?
It will basically just remove all the rows out of the Traps (and trapvarbinds) table(s). The tables are dependent on each other and useless with out the matching data in one another. The only "danger" is that the traps in those tables are gone. Of course you could/should make a full backup of the database and you could keep it in case you need to go back and find some of the trap data. Also issue the command at the same time so they stay in sync (that not super important, just best).
