Anyway to set custom thresholds for SQL Server

[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

[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.

[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

[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.