Search Exchange
Search All Sites
Nagios Live Webinars
Let our experts show you how Nagios can help your organization.Login
New ListingsDirectory Tree
check_mssql_monitor
Meet The New Nagios Core Services Platform
Built on over 25 years of monitoring experience, the Nagios Core Services Platform provides insightful monitoring dashboards, time-saving monitoring wizards, and unmatched ease of use. Use it for free indefinitely.
Monitoring Made Magically Better
- Nagios Core on Overdrive
- Powerful Monitoring Dashboards
- Time-Saving Configuration Wizards
- Open Source Powered Monitoring On Steroids
- And So Much More!
Retreive workload information (cpu, io and idle percent values) from sp_monitor procedure of Microsoft Sql Server.
The check_mssql_monitor plugin, writing in Perl, use perfdata array to store the response values for historical and graphical use.
Support also, for cpu and io, warning and critical threshold values.
(e.g. --cpuWarning=40 --cpuCritical=80 --ioWarning=30 --ioCritical=60)
The check_mssql_monitor plugin, writing in Perl, use perfdata array to store the response values for historical and graphical use.
Support also, for cpu and io, warning and critical threshold values.
(e.g. --cpuWarning=40 --cpuCritical=80 --ioWarning=30 --ioCritical=60)
Reviews (1)
byfhermann, February 5, 2013
This is a very nice plugin, but be warned that it will require "sysadmin" privileges on SQL server to run.
Considering that you will also need to activate TCP/IP remote connection and plain SQL authentication for your nagios user to connect to the SQL database, that could be a major security hole in your infrastructure if you do not properly lock the connections between your monitoring server and your SQL Server.
There is some methods you can use to mitigate the risk, including creating a dedicated database for this monitoring, with a dedicated user, and a dedicated stored procedure, as explained here:
http://www.sqlapprentice.net/?p=108
But I would love to have a plugin who could just perform a basic SQL test without requiring admin privileges to the master system database.
Considering that you will also need to activate TCP/IP remote connection and plain SQL authentication for your nagios user to connect to the SQL database, that could be a major security hole in your infrastructure if you do not properly lock the connections between your monitoring server and your SQL Server.
There is some methods you can use to mitigate the risk, including creating a dedicated database for this monitoring, with a dedicated user, and a dedicated stored procedure, as explained here:
http://www.sqlapprentice.net/?p=108
But I would love to have a plugin who could just perform a basic SQL test without requiring admin privileges to the master system database.
