SQL-DB Services-Unknown Status
ravishankar.gundlapali at wipro.com
ravishankar.gundlapali at wipro.com
Fri Sep 10 18:13:19 CEST 2010
When I ran the command ./check_nrpe -t 60 -H <Hostname> -p 5666
get_mssql_log_used
I got the below output....
I (0.3.5.1 2008-09-24) seem to be doing fine...
Please provide any clue...
Regards,
Ravi G
From: Greg Pangrazio [mailto:pangrazi at gmail.com]
Sent: Friday, September 10, 2010 8:22 PM
To: Nagios Users List
Subject: Re: [Nagios-users] SQL-DB Services-Unknown Status
what does the NRPE config look like on the remote end? Are you allowed
to run commands? What result do you get if you run
check_nrpe -t 60 -H $HOSTADDRESS$ -p 5666 -c get_mssql_log_used -a
$HOSTADDRESS$
with the proper variables from the command line on your nagios server?
Greg Pangrazio
On Fri, Sep 10, 2010 at 8:49 AM, <ravishankar.gundlapali at wipro.com>
wrote:
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
------------------------------------------------------------------------
------
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/f658527a/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/f658527a/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/f658527a/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/f658527a/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/f658527a/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
More information about the Users
mailing list