I'm having a problem where NPM appears to stop updating the database and by extension the data displayed on the web page. This results in our monitoring technician looking at data that is not accurate.
We're running Orion 8.5 SLX on Win 2003 SP2 our database is SQL Express 2005. Current monitoring load is 2362 total elements, my polling completion is always at least 99.3%
Anyone have an idea what could be causing my database not to update/sync?
On a related note, does anyone know if it is possible to create an alert that will trigger if the Last Database Update exceeds a predetermined value?
TIA
I had a similar issue with the Custom MIB Poller. I have to restart the Custom MIB Poller service to fix the issue. After talking to tech support, it is very possible that my configuration (SQL Server is on the same server) could be causing the issue.
I have a scheduled task to restart the service once a day. It only take a few seconds and is a simple batch file.
Bo
aynov:I had a similar issue with the Custom MIB Poller. I have to restart the Custom MIB Poller service to fix the issue. After talking to tech support, it is very possible that my configuration (SQL Server is on the same server) could be causing the issue. I have a scheduled task to restart the service once a day. It only take a few seconds and is a simple batch file. Bo
I suspected the problem might be with the SQL Server. Ours is also on the same box. We are in the process of migrating to an enterprise version of SQL perhaps moving the Orion Database to it will solve the problem.
Which service are you restarting? I tried a daily restart of the NetPerfMon Service a while back to no avail. Perhaps reloading the SQL server daily will ease the problem.
How big is your database? SQL 2005 Express has a limit of 4GB. If your database is close to or bigger that is probably your problem.
Chris
toph:How big is your database? SQL 2005 Express has a limit of 4GB. If your database is close to or bigger that is probably your problem. Chris
My Database comes in at about 2.5GB. I don't keep data for very long due to the 4GB limit. We are in the process of purchasing MSSQL for our Enterprise, a very expensive venture that is going to take some time. Until then, I am stuck with the express edition.
While I'm on the subject of databases, does anyone know if Orion can be configured to write to MySQL?
toph:.While I'm on the subject of databases, does anyone know if Orion can be configured to write to MySQL?
.
My Custom MIB Poller does the same thing and we have our SQL on a separate server. I'm curious what the batch file looks like that restarts the service.
Ask and ye shall receive:
net stop solarwindscustompollingservicenet start solarwindscustompollingservice
And then I just used Windows Task Scheduler to schedule the task to run once a day.
SP3 could fix this issue, which looks to be in the release notes. I am just too paranoid to verify it. And this does not hurt anything.
Thanks for the info.
I'm going to be installing SP3 this week, so I guess I'll find out.
I was having a similar problem with the Custom MIB service - the cause turned out to be a memory leak, which caused the service to fail after using up 900MB of memory. Before you restart the service open up the task manager and check out the usage to see if this is affecting you.
Problem was resolved in SP3.