SQL-DB Services-Unknown Status

[ravishankar.gundlapali at wipro.com]

Hi,

 

Please see the service definition and command definition which I am
using for SQL-DB-LOG-USED and SQL-DB-LOG-GROWTH.

 

Request you to provide a clue on this.

 

 

define service{

        use                             generic-service         ; Name
of service template to use

        host_name                      abcd

        service_description             SQL-DB-LOG-USED

        is_volatile                     0

        check_period                    24x7

        max_check_attempts              3

        normal_check_interval           5

        retry_check_interval            1

        contact_groups                  sql-admins

        notification_interval           0

        notification_period             24x7

        notification_options            c,r

        check_command                 check_nrpe_mssql_log_used!*!50!90

  }

 

 

 

define service{

        use                             generic-service         ; Name
of service template to use

        host_name                 abcd

        service_description             SQL-DB-LOG-GROWTH

        is_volatile                     0

        check_period                    24x7

        max_check_attempts              3

        normal_check_interval           5

        retry_check_interval            1

        contact_groups                  sql-admins

        notification_interval           0

        notification_period             24x7

        notification_options            c,r

        check_command
check_nrpe_mssql_log_growths!*!5000!9000 ; Log growth scale is 0.01
hence 5000 and 9000

  }

 

 

define command {

                command_name
check_nrpe_mssql_log_used

                command_line                    $USER1$/check_nrpe -t 60
-H $HOSTADDRESS$ -p 5666 -c get_mssql_log_used -a $HOSTADDRESS$ "$ARG1$"
"$ARG2$" "$ARG3$"

}

 

 

define command {

                command_name
check_nrpe_mssql_log_growths

                command_line                    $USER1$/check_nrpe -t 60
-H $HOSTADDRESS$ -p 5666 -c get_mssql_log_growth -a $HOSTADDRESS$
"$ARG1$" "$ARG2$" "$ARG3$"

}

 

Thanks,

Ravi G

From: Greg Pangrazio [mailto:pangrazi at gmail.com] 
Sent: Friday, September 10, 2010 6:40 PM
To: Nagios Users List
Subject: Re: [Nagios-users] SQL-DB Services-Unknown Status

 

before anyone can help you we need the parts of the config that are
important here.  Can you give us the command definition, service
definition and any other relevant part of the config?




On Fri, Sep 10, 2010 at 2:28 AM, <ravishankar.gundlapali at wipro.com>
wrote:

Hi All,

 

Request you to help me on this.

 

Thanks,

Ravi G

 

From: Ravishankar Gundlapali (WT01 - Energy and Utilities) 
Sent: Thursday, September 09, 2010 3:42 PM
To: 'Nagios Users List'
Subject: SQL-DB Services-Unknown Status

 

Hi,

 

I am using Nagios Version 3.0.6 on a Linux server to monitor the
SQL-DB-LOG-GROWTH and SQL-DB-LOG-USED on the Windows servers.

 

For the many of the servers the status information is showing following
errors. Please see the screenshots below

 

1)      UNKNOWN: No handler for that command 

2)      Unknown - * query: No row returned. 

3)      CHECK_NRPE: Received 0 bytes from daemon. Check the remote
server logs for error messages.

4)     Unknown - No data received from WMI: 

 

I am using the following the check commands 

 

check_nrpe_mssql_log_used!*!50!90

check_nrpe_mssql_log_growths!*!5000!9000

 

Please someone let me know how can I resolve this. 

 

 

 

 

 

 

Thanks & Regards,

Ravi G

 

 


------------------------------------------------------------------------
------
Automate Storage Tiering Simply
Optimize IT performance and efficiency through flexible, powerful,
automated storage tiering capabilities. View this brief to learn how
you can reduce costs and improve performance.
http://p.sf.net/sfu/dell-sfdev2dev
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when
reporting any issue.
::: Messages without supporting info will risk being sent to /dev/null

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20100910/b14e5a04/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 3817 bytes
Desc: image001.png
URL: <https://www.monitoring-lists.org/archive/users/attachments/20100910/b14e5a04/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 3787 bytes
Desc: image002.png
URL: <https://www.monitoring-lists.org/archive/users/attachments/20100910/b14e5a04/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 6116 bytes
Desc: image003.png
URL: <https://www.monitoring-lists.org/archive/users/attachments/20100910/b14e5a04/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.png
Type: image/png
Size: 3787 bytes
Desc: image004.png
URL: <https://www.monitoring-lists.org/archive/users/attachments/20100910/b14e5a04/attachment-0003.png>
-------------- next part --------------
------------------------------------------------------------------------------
Automate Storage Tiering Simply
Optimize IT performance and efficiency through flexible, powerful, 
automated storage tiering capabilities. View this brief to learn how
you can reduce costs and improve performance. 
http://p.sf.net/sfu/dell-sfdev2dev
-------------- next part --------------
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null