On Tuesday 30 July 2002 06:20 am, Scott Prater wrote: > Hello, all -- > > Does anyone out there have a script they use to monitor Microsoft's SQL > Server from a Unix box? I've started looking into writing my own, but it's > turning out to be more complicated than I initially thought... >
If I had to do this now, I'd probably use perl DBI from the mon server, if I could, to test a remote SQL Server. Failing that, if I had an SNMP agent on the windows box that allowed me to write extension scripts, I'd write (or have the SQL Server DBA write) a little batch file or perl script on the local host to test the SQL server and output mon-friendly output. Failing that, I'd write (or have the SQL Server DBA write) a perl script to test the SQL server on the local MS host and send a mon trap on failure. When I actually monitored SQL Server hosts in production previously, we used the Concord (nee Empire) SNMP agent on our NT boxes. The Concord agent allows one to access the running services and their status as OID's. We tested SQL Server in conjunction with the ntservice.monitor. The Concord agent also allows you to define custom extension scripts, but we didn't use them for SQL Server monitoring.
