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

SNMP data not written to database at night

Has anyone seen this problem? SNMP data seems to not be collected during the hours of 11:00 pm and 5:00 am every day. This has been going on ever since I purchased Orion in May 2007. Ping data is always good, only SNMP seems to be affected. I have included a screen shot to illustrate. Also, Solarwinds support has not been able to resolve this and I believe they have given up, so I hope that someone out there has some suggestions before I scrap the product.

Some things we have done to troubleshoot.

Moved SQL database from external cluster back to the local system
Reinstalled the product (many times, Solarwinds support has also done this remotely)
Applied all hot fixes
Adjusted Polls per second.
Reduced poll frequency
Verified that no other apps are running during that time frame. (backups, AV scans)
Orion server is not taxed. CPU runs around 20%

Even data on the Orion server itself has drop outs

Find more posts tagged with

solarwinds_support

SNMP

Accepted answers

All comments

jeffeager

We have seen a similar problem and opened a ticket with support. They recommending adjusting the polling time from 5 to 4 minutes. This did not help. No further direction as of yet.

Network_Guru

What time does your nightly maintenance start & finish?
This normally happens due to the maintenance script locking some tables in the DB & data can no longer be written to the DB.

Check this file in your Orion installation folder for the nightly DB maint. timestamps:
....\Program Files\SolarWinds\Orion\swdebugMaintenance.log

2007-10-01 02:15:54,919 [1] INFO DatabaseMaintenanceGui.Program - Database Maintenance Starting.
2007-10-01 02:15:54,950 [1] INFO DatabaseMaintenanceGui.Program - Database Maintenance running in automated mode.
2007-10-01 02:15:54,981 [1] INFO SolarWinds.Data.DatabaseMaintenance.Settings - Retaining Detailed for 35
2007-10-01 02:15:54,997 [1] INFO SolarWinds.Data.DatabaseMaintenance.Settings - Retaining Hourly for 65
2007-10-01 02:15:54,997 [1] INFO SolarWinds.Data.DatabaseMaintenance.Settings - Retaining Daily for 370
2007-10-01 02:15:54,997 [1] INFO SolarWinds.Data.DatabaseMaintenance.Settings - Retaining Events for 365
2007-10-01 02:15:54,997 [1] INFO SolarWinds.Data.DatabaseMaintenance.Settings - Retaining Wireless Sessions for 30
2007-10-01 02:15:55,122 [1] INFO SolarWinds.Data.DatabaseMaintenance.MaintenanceEngine - Begining Maintenance
<SNIP>
2007-10-01 02:49:05,517 [1] INFO SolarWinds.Data.DatabaseMaintenance.MaintenanceEngine - Removing older data from VolumeUsage
2007-10-01 02:49:05,580 [1] INFO SolarWinds.Data.DatabaseMaintenance.MaintenanceEngine - Finializing maintenance for VolumeUsage
2007-10-01 02:49:05,580 [1] INFO SolarWinds.Data.DatabaseMaintenance.NetworkElements - Clearing Deleted Nodes
2007-10-01 02:49:05,580 [1] INFO SolarWinds.Data.DatabaseMaintenance.NetworkElements - Clearing Deleted Interfaces
2007-10-01 02:49:05,580 [1] INFO SolarWinds.Data.DatabaseMaintenance.NetworkElements - Clearing Deleted Volumes
2007-10-01 02:49:05,580 [1] INFO SolarWinds.Data.DatabaseMaintenance.MaintenanceEngine - Database Maintenance Complete.

I have about a one hour gap in all my stats at this time every monring.
This has been an ongoing issue for over 3 years for me & have been unable to resolve it.

FormerMember

Database maintenance runs at 8:15 am

2007-10-01 08:15:59,849 [1] INFO DatabaseMaintenanceGui.Program - Database Maintenance Starting.

2007-10-01 08:23:05,514 [1] INFO SolarWinds.Data.DatabaseMaintenance.MaintenanceEngine - Database Maintenance Complete.

jeffeager

We are writing to an external SQL DB. No log file on Orion server.

Network_Guru

We are writing to an external SQL DB. No log file on Orion server.

Have you checked for this file in your Orion directory?
This is a job which runs from a DLL included in Orion & is based on the settings you provide in System Manager for data retention.
If this log file does not exist on your server, then you will be keeping detailed statistics forever & you DB will just keep growing, unless you manually truncate the DB.

In any case, it appears this is not the issue for Mark, as his maint runs at 8:15AM.
It was just something to check.....

bbusbey

We also loose SNMP data and it mainly affects the additional poller.

I have been rebooting the both pollers every morning, this has helped but still it can just quit polling at any random time.

I have setup an alert on the packets per second as was suggested in another posting with the same issue.

I have worked with our DBA to try and find out why this happens and the DBA is at a loss because the data is going into the database but just the SNMP will not post sometimes.

I have opened many cases on the issue going back to 7.5 but the problem still occurs and we just have to deal with it.

Maybe someday Solarwinds will fix it, it would be nice to have a diag program that might self diagnose the problem.

Bruce