1 of 1 people found this helpful
I spoke with my DBA (Database Admin) and he stated that it would be best if the application (Solarwinds) purged the data so I am still not sure what will happen if data is purged on his end. However, I did find out how to purge data from the Solarwinds end specifically for the dbo.syslog table.
1) In your web console go to Settings\All Settings\Polling Settings
2) Scroll down to Database Settings and change the SYSLOG MESSAGES RETENTION from 7 days to a smaller number; in my case I changed it to 3. I believe 7 is default.
3) Then log into your Server Solarwinds is installed on
4) Go to Start Menu\All Programs\SolarWinds Orion\Advanced Features\Database Maintenance
5)Click the "Start" button and wait until the Database Maintenance finishes. In my case there was a lot of data that needed to be purged so it took a few hours but after completion there was a lot of free space available in the database.
KB's relevant to your question
Warning about the size of Syslog table - SolarWinds Worldwide, LLC. Help and Support - how to clean up the syslog/traps tables
Tips and tricks for managing traps and syslog in Orion NPM - SolarWinds Worldwide, LLC. Help and Support - how to set up rules to drop types of messages that you don't need. This is where i find most people need to spend their efforts, 99% of the syslogs coming in are usually just noise and server no value within the solarwinds context.
Thank you mesverrum. I'll definitely look into this as well.