I only wish it were so easy. Unfortunately, there is no perl DBI for SQLServer; from what I've seen on the web, most people hack together solutions with DBI::Proxy and DBD::ODBC, but it is by no means a trivial process. Given my prior experience with the joys of ODBC, I'd like to avoid going down that particular road.
I've also seen that some people have had success DBD::Sybase, but that solution is also fraught with perils and complications, and does not uniformly work for all versions of SQL Server. Being a happy Perl hacker, I'd like to write a perl script to do the monitoring. Failing that, I could also use JDBC, and write my monitor script in Java. Uggh, but a possible solution. Andrew's proposed solution of using the Concord SNMP agent on Windows boxes to send a trap sounds intriguing. Does anyone have comments on other preferred SNMP agents for Windows2000? We've had many, many battles and problems with the Microsoft-supplied agent, and have ended up junking it. I've played a little with Net-SNMP on Windows, but it really didn't do all that I had hoped. Scott Prater Dpto. Sistemas [EMAIL PROTECTED] SERVICOM 2000 Av. Primado Reig, 189 entlo. 46020 Valencia - Spain Tel. (+34) 96 332 12 00 Fax. (+34) 96 332 12 01 www.servicom2000.com > -----Mensaje original----- > De: Ted Serreyn [mailto:[EMAIL PROTECTED]] > Enviado el: martes, 30 de julio de 2002 16:19 > Para: Scott Prater > Asunto: Re: script to monitor SQLServer? > > > Why not look at the mysql monitor script and modify to look at the > correct port and run the correct commands? > > Ted Serreyn > > On Tue, 2002-07-30 at 08:20, 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... > > > > Thanks in advance, > > > > -- Scott > > > > Scott Prater > > Dpto. Sistemas > > [EMAIL PROTECTED] > > > > SERVICOM 2000 > > Av. Primado Reig, 189 entlo. > > 46020 Valencia - Spain > > Tel. (+34) 96 332 12 00 > > Fax. (+34) 96 332 12 01 > > www.servicom2000.com > > > > > > >