Page 1 of 1
Anyway to set custom thresholds for SQL Server
Posted: Tue Mar 29, 2016 3:17 pm
by bmurtha
Hi Nagios Community,
I was wondering if there is anyway to set custom thresholds for SQL Server Plugins. For instance I'm getting alerts about:
MSSQL Lock Requests Per Sec
MSSQL Lock Wait Times
MSSQL Page Looks Per Sec
MSSQL Stolen Pages
MSSQL Target Pages
Is there anyway to set custom thresholds for these alerts or are they baked into the plugin itself.
Regards,
Bryan
Re: Anyway to set custom thresholds for SQL Server
Posted: Tue Mar 29, 2016 4:21 pm
by rkennedy
Which plugin in particular are you referring to? Each one is a bit different, and with that in mind some are hardcoded, where as some are not.
Re: Anyway to set custom thresholds for SQL Server
Posted: Wed Mar 30, 2016 8:49 am
by bmurtha
The SQL Server Plugin the one that produces these:
MSSQL Average Wait Time
Problem has been acknowledgedThis service problem has been acknowledgedNotifications are disabled for this service
Critical 19d 12h 24m 22s 5/5 2016-03-30 09:34:16 CRITICAL: Average Wait Time (ms) is 64.5395894428ms
MSSQL Database Pages
Problem has been acknowledgedThis service problem has been acknowledged
Critical 19d 12h 22m 28s 5/5 2016-03-30 09:30:59 CRITICAL: Database pages are 118844.0
MSSQL Free Pages
Problem has been acknowledgedThis service problem has been acknowledged
Critical 12d 17h 18m 17s 5/5 2016-03-30 09:32:20 CRITICAL: Free pages is 26736.0
MSSQL Lock Requests Per Sec
Critical 19d 12h 23m 48s 5/5 2016-03-30 09:34:45 CRITICAL: Lock Requests / Sec is 129.097512347/sec
MSSQL Lock Wait Times
Critical 18d 11h 36m 38s 5/5 2016-03-30 09:32:10 CRITICAL: Lock Wait Time (ms) is 22008.0ms
MSSQL Page Looks Per Sec
Critical 19d 12h 22m 39s 5/5 2016-03-30 09:35:41 CRITICAL: Page Lookups Per Second is 260.595982191
MSSQL Stolen Pages
Critical 19d 12h 25m 41s 5/5 2016-03-30 09:33:22 CRITICAL: Stolen pages are 7012.0
MSSQL Target Pages
Re: Anyway to set custom thresholds for SQL Server
Posted: Wed Mar 30, 2016 10:27 am
by rkennedy
Can you navigate to Configure -> Core Config Manager -> Click 'Services' on the left, and find those services in question? From there click the screwdriver/wrench icon to 'Edit' them. You should be able to modify the values there in one of the $ARG#$ value's.
If you get confused, please post a screenshot of the above page, and copy / paste your current $ARG#$ values.