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

Monitoring Orion NetPerfMon database (SQL User Experience Monitor)

Hi,

I was wondering which SQL query would be useful to query on that database to get some kind of health indication, does anybody know?

Find more posts tagged with

Accepted answers

All comments

macnugetz

Which version of SQL are you using for your Orion database, and what types of health indicators are you looking for? APM ships with several different SQL monitors, but it would be helpful to know exactly what you're trying to do.

-Craig

Questionario

We are running SQL Server 2008 Enterprise

I actually dont even really know what I am looking for, for one I would just like to pull anything just to get the response time so i can see if or when the database is slow. as we can also get a return value with the sql user experience monitor, some kind of health indicator would be nice also (something like ms per transaction, seconds since last write operation in table X to see if Orion has lost the database connection once again, etc.)

Questionario

any suggestions Craig?

jiri.tomek

Hello Questionario,
You can use for example:

SELECT DATEDIFF(second, [KeepAlive], GETDATE())FROM [Engines]WHERE [ServerType] = 'Primary'

Engines table [KeepAlive] should be updated every two seconds by Orion so if above query returns value greater than 2, there may be an issue with database connection from Orion.

julrich

Here is what I am using

Polling Completion:(percentage of how much is actually getting polled compared to how much is trying to get polled)

SELECT PollingCompletion from NetPerfMon..Engines where IP=${IP}

Last Network Performance Monitor Update:(Minutes since last sync of netperfmon data)

Select DATEDIFF(n,KeepAlive,GETDATE()) From NetPerfMon..Engines where IP=${IP}

Last Syslog Update:(Minutes since last sync of syslog data)

Select DATEDIFF(n,SysLogKeepAlive,GETDATE()) From NetPerfMon..Engines where IP=${IP}

Last Trap Update:(Minutes since last sync of trap data)

Select DATEDIFF(n,TrapsKeepAlive,GETDATE()) From NetPerfMon..Engines where IP=${IP}

Questionario

Hi,

am I correct that these monitors wont actually alert if the connection to the database is lost as the advanced alert engine relies on the database to alert?

Is there any way to >alert< if those monitors go down or rather if the database connection is lost?

julrich

You could create a job in your database to run every 5 mins, run those queries, and email out if conditions are met, or use another monitoring software like nagios to monitor Orion.

We use Nagios for monitoring other things around here so I monitor Orion with Nagios and Nagios is monitored by Orion.

Questionario

well, we actually want to get away from exactly that. The strategy was to consolidate to only one monitoring tool but this one thing is really keeping us from that goal...

Ralphr

If you have Kiwi you can use a combination of that and the Solarwinds Event Log Agent to e-mail you when specified events (like an Orion service shutting down or recording of alert errors ) occur.

Questionario

doesnt work for us... too many errors on the solarwinds server for that :P

also the main issue why orion stops alarming for us is that it loses the connection to the database...

and last but not least... we could monitor it with OpManager even but I am trying to get rid of OpManager :P