SQL Server monitoring

[Dennis Hopp]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20051219/4fd7dfdd/attachment.html>