MSSQL Monitoring - Help Needed

[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

[MaterazziSan]

Hi,

You are missing a Perl library dependency.

Which operative system is hosting that database?

Best regards

[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...

[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 !

[DileepKumar]

Hi,

You are missing a Perl library dependency.

Which operative system is hosting that database?

Best regards

MSSQL is being hosted on remote Windows

[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.