Search found 2 matches

by worx1986
Fri Sep 29, 2017 3:07 pm
Forum: Nagios XI
Topic: Monitoring and Alerting For Long Running Queries (MSSQL)
Replies: 5
Views: 4610

Re: Monitoring and Alerting For Long Running Queries (MSSQL)

Hello @dwasswa! We're currently using the check_mssql plugin, however I'm not seeing any way to alert on queries that last longer than 10 seconds? The closest thing I'm seeing is the MSSQL Query Wizard, that allows you to run an on demand query and view statistics, but nothing that constantly monito...
by worx1986
Thu Sep 28, 2017 3:10 pm
Forum: Nagios XI
Topic: Monitoring and Alerting For Long Running Queries (MSSQL)
Replies: 5
Views: 4610

Monitoring and Alerting For Long Running Queries (MSSQL)

Hello! I'm attempting to monitor and alert for MSSQL queries that take longer than 10 seconds to complete, but I'm having some problems getting this accomplished. Would it be possible to take the output of the below query and somehow pipe it into Nagios? Please let me know if more information is nee...