Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

What happens is i purge space in my dbo.syslog?

I need space and my dbo.syslog is taking up the most. What would happen if I deleted half of what's in here on the database side? Anything bad?

Find more posts tagged with

Accepted answers

kange0010

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.

All comments

kange0010

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

mesverrum

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.

kange0010

Thank you mesverrum. I'll definitely look into this as well.