Nagios and SQL Server 2003

[Thibault Genessay]

Hi Julien

REMY Julien wrote:
> 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 perform check_tcp on port 1433 (by default - I had told you 
1443 in a previous email, that I sent to you only ... holidays get 
closer, thanks god). 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 interesting values such as 
the number of clients connected, the number of transactions per second 
and the like.

Cheers

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