SQLServer

Check MSSQL DataBases, Jobs, Log Files, Time2Connect

Write a Review

Description:

Script for nagios to check MSSQL DataBases, Connection Time, Jobs, TempDB Size, Log Size.
The script get all sql instances in the server, and return status for eache instance
You can use check_mssql_config.ini to exclude DB or instance to check, read check_mssql_config.ini help.

Current Version

1.1.2

Last Release Date

2018-12-05

Compatible With

  • Nagios 3.x
  • Nagios 4.x
  • Nagios XI

Owner

Yossi Bitton

Website

https://github.com/yosbit/nagios-plugins/

Download URL

https://github.com/yosbit/nagios-plugins/blob/master/README/README_check_mssql.md

License

GPL

Copy Page Link Recommend Contact Owner 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 Photos
Project Notes
## Description: Script for nagios to check SQL DataBases, Connection Time, Jobs, TempDB Size, Log Size. The script get all sql instances in the server, and return status for eache instance You can use check_mssql_config.ini to exclude DB or instance to check, read check_mssql_config.ini help. ## Auther: Yossi Bitton [email protected] Date: November 2018 Version 1.1.2 ## PARAMETER DBStatus Get the database status, return critical if one DB not in normal state. ## PARAMETER ConnectionTime Get the time to connect to DB, include performance data. ## PARAMETER Jobs Get the status off all jobs, the script check only Enabled and scheduled jobs. ## PARAMETER TempDBSize Get the size of temp DB. see values of warning and critical in check_mssql_config.ini config. needs dbowner permissions for user Service Account. ## PARAMETER LogSize Get the size of Log file for eache DB. see values of warning and critical in check_mssql_config.ini config. needs dbowner permissions for user Service Account. ## EXAMPLE ./check_nrpe -H -c check_mssql -a 'DBStatus' ./check_nrpe -H -c check_mssql -a 'ConnectionTime' ./check_nrpe -H -c check_mssql -a 'Jobs' ./check_nrpe -H -c check_mssql -a 'TempDBSize' ./check_nrpe -H -c check_mssql -a 'LogSize' for Nagios NRPE edit NSC.ini or nsclient.ini and add the following line under section: [Wrapped Scripts] check_mssql=check_mssql.ps1 $ARG1$ [Script Wrappings] ps1 = cmd /c echo scripts%SCRIPT% %ARGS%; exit($lastexitcode) | powershell.exe -ExecutionPolicy Bypass -command -
Reviews (3) Add a Review
No output returned from plugin
by simob82, July 31, 2019
Hi!
I'm facing some trouble make it working, when I run the plugin from nagios server it works fine:
#---------------------------------------------------------------------------------------------------------------------------------------#
/usr/lib/nagios/plugins/check_nrpe -H 10.10.104.171 -t 30 -c check_mssql -a ConnectionTime

OK: Time to connect for all instances are OK. Total Instances=1.
MSSQLSERVER=0.0388237. |'MSSQLSERVER time to connect'=0.03882;3;5;0.03882
#------------------------------------------------------------------------------------------------------------------------------------------#
But I don't have any output, and I still have Status "unknow" and "no output returned from plugin".
As reported I've added these lines on my nsclient.ini

#---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------#
[/settings/external scripts/scripts]
; check_mssql = cmd /c echo scripts\check_mssql.ps1 "$ARG1$" ; exit($lastexitcode) | powershell.exe -ExecutionPolicy Bypass -command -

; CheckExternalScripts.dll

[Script Wrappings]
; vbs=cscript.exe //T:30 //NoLogo scriptslibwrapper.vbs %SCRIPT% %ARGS%
; bat=scripts%SCRIPT% %ARGS%
; ps1 = cmd /c echo scripts\%SCRIPT% %ARGS%; exit($lastexitcode) | powershell.exe -ExecutionPolicy Bypass -command -
ps1 = cmd /c echo scripts%SCRIPT% %ARGS%; exit($lastexitcode) | powershell.exe -ExecutionPolicy Bypass -command -
; ps1=cmd /c echo scripts\\%SCRIPT% %ARGS%; exit($lastexitcode) | powershell.exe -command -

[Wrapped Scripts]
check_mssql=check_mssql.ps1 $ARG1$

[/settings/external scripts]
allow arguments = true
;use_file = 1
#-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------#
I made a lot of try and as you can see I've commented in/out some lines =)
Could please give me any hint?? I'm without ideas!

Thank in advance
Helpful?    
Report
Very helpful
by sajid4u, May 31, 2019
It is excellent in pulling details of jobs, DB status at server and its respective instance level monitoring.

But I am facing challenges in configuring it cluster and instance level. Does this support such case? Please suggest.
Helpful?    
Report
Good Script but one error
by bulgod, July 31, 2017
The script work but in Nagios while 1 database is stopped wont stay RED. Continue Green
Owner's Reply:

fixed in version 1.1.2

1 of 1 found this review helpful.
Helpful?  1  0
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 Photos Project Notes Reviews
Project Stats
Rating
4.4 (5)
Favorites
1
Views
27,881