[prev in list] [next in list] [prev in thread] [next in thread]
List: nagios-users
Subject: Re: [Nagios-users] Anybody use check_mssql_health plugin?
From: Andrew Thompson <andrew () fulgent ! co ! uk>
Date: 2012-12-07 11:25:59
Message-ID: A52C996F892310499AF1F3DDA60A9E6DA19858A8 () FTLMAIL ! evesham ! fulgent ! co ! uk
[Download RAW message or body]
Hello Robert,
This is my command:
# 'check_mssql_health CPU Usage' command definition
define command{
command_name check_sql_cpu
command_line $USER1$/check_mssql_health -server $HOSTADDRESS$ -usern=
ame $ARG1$ -password $ARG2$ -mode $ARG3$
}
This is my service check for said server:
define service{
use service-sql-server,srv-pnp
host_name ABCDEF
service_description CPU USAGE
check_command check_sql_cpu!"user"!pass!cpu-busy!
}
Cheers
From: Werner, Robert [mailto:RWerner@pomwonderful.com]
Sent: 06 December 2012 22:05
To: Nagios Users List
Subject: Re: [Nagios-users] Anybody use check_mssql_health plugin?
I didn't know you could check the CPU status with that plugin.
What is the command definition that you are using?
--
Robert G. Werner
Oracle Apps Systems Administrator
rwerner@pomwonderful.com<mailto:rwerner@pomwonderful.com>
559.521.5089
________________________________
From: Andrew Thompson [andrew@fulgent.co.uk]
Sent: Thursday, December 06, 2012 4:48 AM
To: nagios-users@lists.sourceforge.net<mailto:nagios-users@lists.sourceforg=
e.net>
Subject: [Nagios-users] Anybody use check_mssql_health plugin?
If so, ever come across this issue before?
Everything works fine apart from 1 server and 1 check.
1 particular Windows 2008R2 server replies its CPU usage as a crazy percent=
age:
[12-05-2012 14:47:35] SERVICE ALERT: XXXXXX;CPU USAGE;CRITICAL;HARD;3;CRITI=
CAL - CPU busy 194180.74%
[12-05-2012 14:44:35] SERVICE ALERT: XXXXXX;CPU USAGE;CRITICAL;SOFT;2;CRITI=
CAL - CPU busy 116508.44%
[12-05-2012 14:41:35] SERVICE ALERT: XXXXXX;CPU USAGE;CRITICAL;SOFT;1;CRITI=
CAL - CPU busy 233016.89%
When I check the server the CPU isn't even using 10% most of the time.
It does this from the terminal aswell, with nagios user and also root user.
Anybody have any ideas as to what can cause this please?
Many Thanks
[Attachment #3 (text/html)]
<html xmlns:v="urn:schemas-microsoft-com:vml" \
xmlns:o="urn:schemas-microsoft-com:office:office" \
xmlns:w="urn:schemas-microsoft-com:office:word" \
xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" \
xmlns="http://www.w3.org/TR/REC-html40"> <head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p
{mso-style-priority:99;
margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.msochpdefault, li.msochpdefault, div.msochpdefault
{mso-style-name:msochpdefault;
margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Calibri","sans-serif";}
span.emailstyle17
{mso-style-name:emailstyle17;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-GB" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">Hello \
Robert,<o:p></o:p></span></p> <p class="MsoNormal"><span \
style="mso-fareast-language:EN-US"><o:p> </o:p></span></p> <p \
class="MsoNormal"><span style="mso-fareast-language:EN-US">This is my \
command:<o:p></o:p></span></p> <p class="MsoNormal"><span \
style="mso-fareast-language:EN-US"><o:p> </o:p></span></p> <p \
class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New \
Roman","serif""># 'check_mssql_health CPU Usage' command \
definition</span><br> define command{<br>
command_name check_sql_cpu<br>
command_line $USER1$/check_mssql_health -server \
$HOSTADDRESS$ -username $ARG1$ -password $ARG2$ -mode $ARG3$<br> \
}<br> <br>
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">This is my service check for said server:<br>
<br>
<o:p></o:p></p>
<p class="MsoNormal"><br>
define service{ <br>
use \
service-sql-server,srv-pnp <br> \
host_name \
ABCDEF <br> \
service_description CPU USAGE<br> \
check_command \
check_sql_cpu!"user"!pass!cpu-busy!<br> }<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Cheers<span \
style="mso-fareast-language:EN-US"><o:p></o:p></span></p> <p class="MsoNormal"><span \
style="mso-fareast-language:EN-US"><o:p> </o:p></span></p> <div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US">From:</span></b><span lang="EN-US"> \
Werner, Robert [mailto:RWerner@pomwonderful.com] <br>
<b>Sent:</b> 06 December 2012 22:05<br>
<b>To:</b> Nagios Users List<br>
<b>Subject:</b> Re: [Nagios-users] Anybody use check_mssql_health \
plugin?<o:p></o:p></span></p> </div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:black">I \
didn't know you could check the CPU status with that plugin. <br>
<br>
What is the command definition that you are using?<o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:black"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:black">--<br>
Robert G. Werner<br>
Oracle Apps Systems Administrator<br>
<a href="mailto:rwerner@pomwonderful.com">rwerner@pomwonderful.com</a><br>
559.521.5089<o:p></o:p></span></p>
</div>
</div>
<div>
<div class="MsoNormal" align="center" style="text-align:center"><span \
style="font-size:12.0pt;font-family:"Times New \
Roman","serif";color:black"> <hr size="2" width="100%" align="center">
</span></div>
<div id="divRpF468592">
<p class="MsoNormal" style="margin-bottom:12.0pt"><b><span \
style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:black">From:</span></b><span \
style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:black"> \
Andrew Thompson [andrew@fulgent.co.uk]<br> <b>Sent:</b> Thursday, December 06, 2012 \
4:48 AM<br> <b>To:</b> <a \
href="mailto:nagios-users@lists.sourceforge.net">nagios-users@lists.sourceforge.net</a><br>
<b>Subject:</b> [Nagios-users] Anybody use check_mssql_health plugin?</span><span \
style="font-size:12.0pt;font-family:"Times New \
Roman","serif";color:black"><o:p></o:p></span></p> </div>
<div>
<div>
<p class="MsoNormal"><span style="color:black">If so, ever come across this issue \
before?<o:p></o:p></span></p> <p class="MsoNormal"><span \
style="color:black"> <o:p></o:p></span></p> <p class="MsoNormal"><span \
style="color:black">Everything works fine apart from 1 server and 1 \
check.<o:p></o:p></span></p> <p class="MsoNormal"><span \
style="color:black"> <o:p></o:p></span></p> <p class="MsoNormal"><span \
style="color:black">1 particular Windows 2008R2 server replies its CPU usage as a \
crazy percentage:<o:p></o:p></span></p> <p class="MsoNormal"><span \
style="color:black"> <o:p></o:p></span></p> <p class="MsoNormal"><span \
style="color:black">[12-05-2012 14:47:35] SERVICE ALERT: XXXXXX;CPU \
USAGE;CRITICAL;HARD;3;CRITICAL - CPU busy 194180.74%<o:p></o:p></span></p> <p \
class="MsoNormal"><span style="color:black">[12-05-2012 14:44:35] SERVICE ALERT: \
XXXXXX;CPU USAGE;CRITICAL;SOFT;2;CRITICAL - CPU busy 116508.44%<o:p></o:p></span></p> \
<p class="MsoNormal"><span style="color:black">[12-05-2012 14:41:35] SERVICE ALERT: \
XXXXXX;CPU USAGE;CRITICAL;SOFT;1;CRITICAL - CPU busy 233016.89%<o:p></o:p></span></p> \
<p class="MsoNormal"><span style="color:black"> <o:p></o:p></span></p> <p \
class="MsoNormal"><span style="color:black">When I check the server the CPU \
isn’t even using 10% most of the time.<o:p></o:p></span></p> <p \
class="MsoNormal"><span style="color:black"> <o:p></o:p></span></p> <p \
class="MsoNormal"><span style="color:black">It does this from the terminal aswell, \
with nagios user and also root user.<o:p></o:p></span></p> <p class="MsoNormal"><span \
style="color:black"> <o:p></o:p></span></p> <p class="MsoNormal"><span \
style="color:black">Anybody have any ideas as to what can cause this \
please?<o:p></o:p></span></p> <p class="MsoNormal"><span \
style="color:black"> <o:p></o:p></span></p> <p class="MsoNormal"><span \
style="color:black">Many Thanks<o:p></o:p></span></p> <p class="MsoNormal"><span \
style="color:black"> <o:p></o:p></span></p> <p class="MsoNormal"><span \
style="color:black"> <o:p></o:p></span></p> <p class="MsoNormal"><span \
style="color:black"> <o:p></o:p></span></p> </div>
</div>
</div>
</div>
</div>
</body>
</html>
[Attachment #4 (--===============7820811473397420316==)]
------------------------------------------------------------------------------
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
http://p.sf.net/sfu/logmein_12329d2d
_______________________________________________
Nagios-users mailing list
Nagios-users@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
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic