SQL-DB Services-Unknown Status

ravishankar.gundlapali at wipro.com ravishankar.gundlapali at wipro.com
Tue Nov 2 15:13:37 CET 2010


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

  

 

 

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 & 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/20101102/714e2830/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/20101102/714e2830/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/20101102/714e2830/attachment-0001.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/20101102/714e2830/attachment-0002.png>
-------------- next part --------------
------------------------------------------------------------------------------
Nokia and AT&T present the 2010 Calling All Innovators-North America contest
Create new apps & games for the Nokia N8 for consumers in  U.S. and Canada
$10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing
Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store 
http://p.sf.net/sfu/nokia-dev2dev
-------------- 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


More information about the Users mailing list