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

SysLog Table in NetPerfMon DB is HUGE

I've been truncating this table to resolve the issue. However, i want to maintain 7 days data. I've tried running the DB maintenance/compact, etc. Nothing seems to shrink it below 50GB. Is there a way to run a SQL script to delete all rows older than 7 days on this table? If so, can someone please let me know what that script would be? The closest thing I've found is this.

Set ROWCOUNT 10
DELETE FROM SysLog WHERE (MONTH(DateTime) = 7) AND (DAY(DateTime) = 9)
SET ROWCOUNT 0

However, I don't want to run this manually on certian rows and keep changing the date, etc. i want to set it up to run automatically. Any assistance would be appreciated. Thanks!

Find more posts tagged with

Accepted answers

All comments

bshopp

Have you set the product syslog retention setting for 7 days? In the syslog viewer on the Orion server, if you go to File -> Setting you can set the retention setting there

pstage

Yes, it is set for 7 days. I asked our Network Admin to only log errors. He was logging informational and notices as well...it was growing 1MB per minute like that.

bshopp

Does he/she need all this additional information in Orion? Just thinking of other ideas here. You can have them go to our Kiwi Syslog server for everything and then forward onto Orion only the stuff you and other engineers need and care about. The logs on the Kiwi server can then be rolled and archived off for compliance purposes. Just an idea