Build precise queries to find exactly what you need
Press ESC to close
Your review has been submitted and is pending approval.
Retreive workload information (cpu, io and idle percent values) from sp_monitor procedure of Microsoft Sql Server.
Current Version
Last Release Date
June 7, 2009
Owner
Nagios Exchange
check_mssql_monitor
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)
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.
You must be logged in to submit a review.
To:
From:
We’ve completely redesigned the world’s largest repository of Nagios plugins and monitoring tools. Join thousands of users sharing monitoring solutions for servers, applications, and everything in between.
Due to our redesign, all existing accounts require a password reset to access your account again.
Ready to explore 6,100+ projects and contribute to the community?
Reset Password Create Account
Happy Monitoring!