SQL Server monitoring

[Alex Moore]

On Mon, 19 Dec 2005 13:10:20 -0600
"Jason" <jboard at nvc.net> wrote:

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

I use the check_mssql plugin from the source contrib directory for
this.  It returns the number of users connected with a pid > 50.  I did
have to make a few slight modifications, but that was probably because
I use Solaris and not Linux.

Alex


-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
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