Page 1 of 1

plugin mssql_server no output stdout

Posted: Fri Sep 23, 2016 7:50 am
by etha
Hello Team,
I'm monitoring some servers of my company and Nagios works well :). However I'm facing an issue with the plugin check_mssql_server. After complete the wizard i have errors with 2 services.
MSSQL Free Pages/MSSQL Stolen Pages. Both have the same errors: Warning (No output on stdout) stderr: Traceback (most recent call last):
I check the plugin with the cmd :

Code: Select all

pagelooks passed!
batchreq passed!
lockwaits passed!
pagereads passed!
totalpages failed with: 'NoneType' object is unsubscriptable
readahead passed!
pagewrites passed!
stolenpages failed with: 'NoneType' object is unsubscriptable
targetpages passed!
fullscans passed!
locktimeouts passed!
freepages failed with: 'NoneType' object is unsubscriptable
bufferhitratio passed!
averagewait passed!
checkpoints passed!
lockrequests passed!
pagelife passed!
databasepages passed!
deadlocks passed!
cachehit passed!
pagesplits passed!
lockwait passed!
lazywrites passed!
sqlcompilations passed!
3/24 tests failed.
All the others servers and services works fine. The version of SQL Server is 2016 Entreprise. I download the OVF template on your website. My Nagios version is up to date (5.2.9)(Trial). My CentOS version is 6.8
Do you have any idea how to solve the problem ?
Thank in advance and have a nice day !

Re: plugin mssql_server no output stdout

Posted: Fri Sep 23, 2016 10:48 am
by rkennedy
Both Free Pages and Stolen Pages were valid in 2008, but they were removed in 2012. See this link - https://blogs.msdn.microsoft.com/vsanil ... -sql-2012/

Re: plugin mssql_server no output stdout

Posted: Mon Sep 26, 2016 12:53 am
by etha
Hello Team,

Thank you for your answer.

Have a nice day.

Re: plugin mssql_server no output stdout

Posted: Mon Sep 26, 2016 12:45 pm
by rkennedy
No problem, you as well!

Closing this one up, but feel free to open a new thread if you have questions in the future.