Eirc, you already have at least 2 monitors you've submitted...however, it's been made easier (on me):
http://www.trantor.org/theshire/doku.php/faq question #2.
=G=
From: Eric Meddaugh [mailto:user-4e1e735fdc96@xymon.invalid]
Sent: Tuesday, May 29, 2007 10:18 AM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] BBwin script monitor sql 2005
I wrote one here to monitor msSQL servers, not sure on the version. It runs from the unix hobbit server, it requires DBD::Sybase and DBI.
The tar needs to be extracted to /home/hobbit/server/ext (change paths in the files if you use a different structure ).
Change the "dbinfo" to reflect your login user/password. You'll have to grant access for the user to "sysservers" to select the "srvname" and "srvid". (see scripts).
You'll just need to add to the host tag, "mssql:<PORT>"
At some point it may be expanded to gather more additional stats and report it as "data" to the hobbit server.
It probably should be put into The Shire, however that is done.
---Eric
From: Jason Chambers [mailto:user-3fa671c0a30d@xymon.invalid]
Sent: Tuesday, May 29, 2007 09:52
To: user-ae9b8668bcde@xymon.invalid
Subject: [hobbit] BBwin script monitor sql 2005
Does anyone know where I can get a script to monitor sql 2005 servers, x64? Deadcat.net appears to be useless now.
Jason Chambers
IT Helpdesk Support
<http://www.geosoft.com/>; eosoft Inc.
XX Richmond St. West - 8th Floor
Toronto, Ontario, Canada
M5H 2C9
Tel: XXX-XXX-XXXX x344
Fax: XXX-XXX-XXXX
www.geosoft.com