Big Metrics


#1

My Organization has around 600 SQL tables. On each of these, we want to check a few metrics. Does anyone know of a better solution to grab these than having a nagios check per metric as we’d end up with around 3k checks


#2

Write one script that has options to check whichever metrics you want. Then output a message listing every check selected which failed. That would cut down your checks to 600 (1 per table) and would only take about an hour to configure.


#3

Also, if for some reason you really wanted to break it out into multiple checks on the nagios interface then you could use passive checking. That would allow you to send back a check per metric within the same script - just change the service name which each sent packet.