Re: Anyone using ISPY?

I have written a tool before ISPY was on the market, to log all SQL statements. These logs are then later analyzed to help me to create indexes where needed, move SQL joins to different disks, etc. The code is in C and very preliminary. I you know C, and interested, I can mail you the code to customize for yourself. The basic a action is simple. Create a listener {open a socket and listen, like telnetd deamon}, accept and then connect to the Informix listener. Pass all the data between connections but log successful SQL statements. I am sure you can easy mod it to log timings, etc. When I have time, I will clean the code and post it to IIUG. Let me know. -----Original Message----- From: Kevin Hunt [SMTP:khhunt@triplecrownsvc.com] Sent: Wednesday, February 02, 2000 8:55 PM To: informix-list@iiug.org Subject: Re: Anyone using ISPY? I tried the Zero Impact Monitor. Very buggy. Neil Truby <ntruby@netcomuk.co.uk> wrote in message news:83b8oo$rv8$1@taliesin.netcom.net.uk... > You don't miss a trick, do you Randy?! > > I think in future i'll scan the pages, never posting everything except to > say, in response to a question "Check out Neil Truby's fantastic, famous > Remote Consultancy service - all informix problems fixed AND your underwear > cleaned whiter than you imagined possible!" > > Now THAT will make c.d.i. a better place, won't it? > > Randy Reiter wrote in message <836j06$ku0$1@bgtnsc01.worldnet.att.net>... > >Refer to the Zero Impact Sql Monitor and Zero Impact Service Level Monitor > >products at www.sqlpower.com. > > > >Zero Impact Service Level Monitor will calculate the end-user service > levels > >(end-user response time and database server response time) by select, > >insert, update, delete, stored procedure, table or column access and more. > > > >The Zero Impact Sql Monitor captures all SQL with its performance. Scales > >to thousands of users and 1000+ transactions/sec with no impact upon the > >database server. Also alerts you to all end-user login failures. > > > >The product line non-intrusively analyzes the SQL network packet flow to > the > >database server for end-user SQL and service level performance monitoring. > >The product does NOT have to run on the database server, NOR on client > >workstations connected to the server. > > > >The products require NO intrusive database server open servers, monitors, > >agents, probes, audits, middleware or proxy servers. NO agents are > >installed on end user workstations. > > > >The products require NO impact upon the database servers, network or > >end-users. The products require no connections to the database server and > >end-users connect directly to the database server (not the monitor). > Product > >installation is a three step process that can be completed in a few > minutes. > > > > > >James Skaife wrote in message <38552C31.56B4D4AD@ucar.edu>... > >>Hi, > >>We're looking for a good usage monitoring tool with reporting features > >>similar to ISPY. Anyone have experience with ISPY and would you > >>recommend it? If not, any other products you would suggest for > >>monitoring/reporting user activity? > >> > >>Thank You! > >>James > >> > >>-- > >>James Skaife > >>DBA/Applications Developer > >>UCAR > >>skaife@ucar.edu > > > > > >