Re: Database statistics tracking.

Just wondering about Zero Impact Sql Monitor. Is it going to work in a switching network (when you are using switches instead of hubs)? In my understanding the monitor must set the network card in promiscuous mode to get all the packets on network. And this should work great in a local network based on thin or thick ethernet, or hubs. And I'm definitely not sure how it works when switches are used. Can someone clear things up ? Best Regards, Octav On Sun, Nov 07, 1999 at 09:00:02PM -0000, Neil Truby wrote: > Hey Randy > > I note from your email address that, by co-incidence, you actually work for > the distributors of these products. Presumably you can let your mates on > c.d.i. have some "under-the-counter" copies then? > > thanks > Neil > > Randy Reiter wrote in message <8002km$luh$1@bgtnsc02.worldnet.att.net>... > >Refer to the Zero Impact Sql Monitor and Zero Impact Service Level Monitor > >products at www.sqlpower.com. > > > >Captures all SQL with its performance. Scales to thousands of users and > >1000+ transactions/sec with no impact upon the database server. > > > >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 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. > > > >CZ <1@2.3> wrote in message ... > >>We are running several databases (for separate clients) on a single > >instance > >>of Informix (7.30.UC7 - Informix for Linux) and we want to monitor traffic > >>for these databases separately. The logs capture the standard UPDATE, > >>INSERT, DELETE but the most common occurences on this machine are SELECT > >>statements. I have gone through the admin guide but I can't find anything > >>that will capture this data. > >> > >>Does anyone have any ideas on how I can track this? Any thoughts would be > >>appreciated. > >> > >>-Clinton > >> > >> > > > > > -- Octav Chiriac Phone: (373) 2 22 99 67 NetInfo S.R.L. Fax: (373) 2 21 36 59 Chisinau (373) 2 22 84 88 Moldova, Republic of mailto:com@netinfo-moldova.com