These queries were provided to me by SolarWinds Support and have had a huge impact on keeping my system running smoothly.
I have never had any trouble running these; however, please be aware of the following:
- Backup your Database before you run these just as a precaution
- The first 3 queries will delete all Traps and Syslogs from your database, this is to speed up the process; these steps can be ignored if you prefer