SQLServer

check_mssql_monitor

Write a Review

Description:

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

Compatible With

Owner

Nagios Exchange

Copy Page Link Recommend Login to Add to Favorites Login to Claim
Nagios CSP

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.

Download Now

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!
Project Files
FileDescription
check_mssql_monitor

check_mssql_monitor

Project Notes
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)
Reviews (1) Add a Review
Require sysadmin Role on SQL Server
by fhermann, February 28, 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.
Helpful?    
Report
Add a Review

You must be logged in to submit a review.

Thank you for your review!

Your review has been submitted and is pending approval.

Recommend

To:


From:


Thank you for your recommendation!

Your recommendation has been sent.

Page Sections
Project Overview Project Files Project Notes Reviews
Project Stats
Rating
3 (1)
Favorites
0
Views
111,592