Nagios and SQL Server 2003

[REMY Julien]

I tried : check_nt -H IP -v SERVICESTAT -s None -l mssql.

Is it correct ?

-----Message d'origine-----
De : Thibault Genessay [mailto:tgenessay at aliadis.fr] 
Envoyé : lundi 24 juillet 2006 17:26
À : REMY Julien
Objet : Re: [Nagios-users] Nagios and SQL Server 2003

Hi Julien

REMY Julien wrote:
> Hello,
> 
> Is it possible to supervise if SQL Server turns on a server ?

I'm hopefully french so I understand that by "turn" you mean "run" :)
Well you can do a check_tcp on port 1443 (default). This will only tell 
you if the TCP agent is listening, but it's a good start.
You can then use WMI (through the check_nt server-side plugin with the 
NC_NET client side software) to retrieve very intersesting values such 
as the number of clients connected, the number of transactions per 
second and the like.

Cheers

PS: are you Julien from Montrevel ?

-- 
Thibault GENESSAY
ALIADIS
www.aliadis.fr
Tel.  +33 4 72 13 90 40
Fax   +33 4 74 22 00 09

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
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