Page 1 of 1
MSSQL Monitoring - Help Needed
Posted: Wed Jun 25, 2025 8:43 am
by DileepKumar
Hi Everyone,
I'm new to Nagios Core and wanted to monitor my MSSQL services
If possible, please provide any plugins that are suitable for the above checks and If possible please do provide/help with command and definitions (Atleast one command and service definition is appreciated) as i have tried some plugins but unable to define commands and service definitions
I have been using check_mssql_health but receiving the error "CRITICAL - could not load perl module DBD::Sybase"
please help
Thank You
Re: MSSQL Monitoring - Help Needed
Posted: Wed Jun 25, 2025 5:39 pm
by MaterazziSan
Hi,
You are missing a Perl library dependency.
Which operative system is hosting that database?
Best regards
Re: MSSQL Monitoring - Help Needed
Posted: Wed Jun 25, 2025 5:53 pm
by kg2857
You need to install the perl module on the nagios server.
On a redhat based system
yum install perl-dbd-sybase
might still work. Things may have changed in more recent OS versions.
For Debian, maybe use apt-get instead of yum...
Re: MSSQL Monitoring - Help Needed
Posted: Thu Jun 26, 2025 8:46 am
by DileepKumar
Thank you @kg2857 and @MaterazziSan for your replies,
Issue is resolved now,
however some of the outputs are like a page length. For example, I was trying to check jobs-failed on my MSSQL DB, check is working fine but unfortunately the output which we are able to see on web UI is a page long, is there a way to configure or customize the output (BTW, I'm using check_mssql_status plugin BY lausser) . Also, tried using --morphmessage but unable to specify or define the correct arguments
Please help !
Re: MSSQL Monitoring - Help Needed
Posted: Thu Jun 26, 2025 8:49 am
by DileepKumar
MaterazziSan wrote: ↑Wed Jun 25, 2025 5:39 pm
Hi,
You are missing a Perl library dependency.
Which operative system is hosting that database?
Best regards
MSSQL is being hosted on remote Windows
Re: MSSQL Monitoring - Help Needed
Posted: Sat Jun 28, 2025 10:58 pm
by kg2857
Nagios looks at the first line of check output and the return value. The page of info is displayed but not interpreted. Check the plugin options to see if the output can be limited.