SQL Server monitoring

[Claudio Elauterio]

Dennis Hopp escreveu:

> You could either use a plugin that connects to the MSSQL server port 
> (1433 by default) and check the response.
>  
> Or
>  
> There are a few plugins that check to see if a result can be obtained 
> from an actual query against mysql, you could adapt that for MSSQL
>  
> Or
>  
> You could use a plugin that will check your website (a page that uses 
> a database lookup) and check to see if the page returns ok or not.
>  
> --Dennis
>
>     ------------------------------------------------------------------------
>     *From:* nagios-users-admin at lists.sourceforge.net
>     [mailto:nagios-users-admin at lists.sourceforge.net] *On Behalf Of *Jason
>     *Sent:* Monday, December 19, 2005 1:10 PM
>     *To:* Nagios List
>     *Subject:* [Nagios-users] SQL Server monitoring
>
>
>     Northern Valley CommuRecently, we had a server issue with one of
>     MSSQL servers.  It never went
>     down, but it did reject any type of connection that would be sent
>     to it.
>     All websites that tried to conenct to a database on that server
>     failed.
>     They all showed RunTime errors.  We have nagios set up to monitor
>     if the SQl
>     servers are physically down, but is there a way to have nagios
>     check the
>     connectivity of a server that is up to see if it is still accepting
>     connections?
>
>     Thanks for your help.
>
>     Thanks
>     Jason B.
>     Hosting Technician
>     Portal Web Hosting
>     Northern Valley Communications nications
>
I´m use this  plugin for MSSQL server...

-- 
_________________________
Cláudio Elautério
Analista de T.I
ICQ: 77872215
MSN: celauter at yahoo.com.br
Fone: 550656172339
Celular: 06599570277
O homem é feito para a luta, não para o repouso.

(Ralph Emerson)

-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: check_mssql.pl
URL: <https://www.monitoring-lists.org/archive/users/attachments/20051219/8602412b/attachment.pl>