plugin mssql_server no output stdout

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
etha
Posts: 2
Joined: Fri Sep 23, 2016 4:13 am

plugin mssql_server no output stdout

Post 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 !
rkennedy
Posts: 6579
Joined: Mon Oct 05, 2015 11:45 am

Re: plugin mssql_server no output stdout

Post 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/
Former Nagios Employee
etha
Posts: 2
Joined: Fri Sep 23, 2016 4:13 am

Re: plugin mssql_server no output stdout

Post by etha »

Hello Team,

Thank you for your answer.

Have a nice day.
rkennedy
Posts: 6579
Joined: Mon Oct 05, 2015 11:45 am

Re: plugin mssql_server no output stdout

Post 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.
Former Nagios Employee
Locked