Re: Tracing ALL sql queries - is it possible?

It depends on where the SQL is coming from, I imagine. If they're typing it in, it would capture it. If they're just telnetting in to kick off a program, I would doubt it. Maybe if the SQL is displayed/copied to the screen--that'd be an interesting question... > In our case we have around 100 users telnetting into a sun box (UE4000) > from a pc - using a 3rd party (Acadia) telnet product. Once connected to > the Sun box and logged in, they establish a connection to the database > using shared memory (since at this point they are local on the sun). > Would this product capture the sqls via the shared memory connection since > they are in fact telnetting in? Is this what you meant? thanks > > Laura A Bishop

Yes, In this situation the SQL is being sent across the network (in a telnet session) by developers, DBAs or end-users. The Sql Power SniFFFer would capture the SQL text, rows returned, database server response time, end-user response time, network send time, network receive time, login id, database server name, and workstation source (ip address and port no.). Likewise database server/end-user service level statistics can be monitored and determined by a DBA/Administrator specified monitoring interval (e.g. 5 sec, 5 min., etc.). Randy Reiter www.sqlpower.com Chuck Renaud wrote in message <7e2mts$1l3$1@news.xmission.com>... > >It depends on where the SQL is coming from, I imagine. If they're >typing it in, it would capture it. If they're just telnetting in to kick off >a program, I would doubt it. Maybe if the SQL is displayed/copied >to the screen--that'd be an interesting question... > >> In our case we have around 100 users telnetting into a sun box (UE4000) >> from a pc - using a 3rd party (Acadia) telnet product. Once connected to >> the Sun box and logged in, they establish a connection to the database >> using shared memory (since at this point they are local on the sun). >> Would this product capture the sqls via the shared memory connection since >> they are in fact telnetting in? Is this what you meant? thanks >> >> Laura A Bishop >