Tracing ALL sql queries - is it possible?
The poster asked whether Informix can dump a trace of all SQL queries with timing information. No built-in server facility was offered; instead two third-party/add-on options were suggested: a vendor pitch for Sql Power SniFFFer / 7x24 Global Sql Monitor, which sniffs network packets to capture SQL and timings without touching the server (with caveats that loopback and shared-memory connections on some platforms can't be seen), and Informix's own I-Spy proxy tool, with rough per-user pricing quoted. The original poster never confirmed which, if any, he adopted, so no definitive resolution is recorded.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi, does anybody know whether it is it possible to dump a trace of ALL sql queries, with timing info, under Informix? Thanks a lot -- Michael Ivanov. Voice: +7 (812) 219-9237. E-mail: ivans@spb.sterling.ru
Yes - with ZERO database server impact. Refer to www.sqlpower.com. Below is a product overview and description of the two Sql Power SniFFFer products for ZERO impact database (Informix IDS) service level and SQL transaction performance monitoring. 1. '7x24 Global Sql Monitor' for 7x24 ZERO impact end-user and database server Service Level Monitoring. 2. 'Sql Power SniFFFer' for ZERO impact SQL transaction capture, performance monitoring and alert notification. Product Overview: ================ The Sql Power SniFFFer product line non-intrusively analyzes the SQL network packet flow to the database server for SQL transaction performance monitoring. The product does NOT have to run on the database server, NOR on any client workstations connected to the database server. The Sql Power SniFFFer products require NO intrusive database server monitors, agents, probes, audits, middleware or proxy servers. NO agents are installed on end user workstations. The Sql Power SniFFFer products require NO impact upon the database servers, network or end-users. The Sql Power SniFFFer requires NO installation of monitoring middleware, ODBC, Informix client connectivity software and MINIMAL on going DBA support. Product installation is a three step process that can be completed in a few minutes. The Sql Power SniFFFer product line is currently available for all versions of Informix (IDS) database servers. Product Line: ============ Sql Power SniFFFer: ------------------ The 'Sql Power SniFFFer' captures, analyzes and monitors the performance of all SQL transactions to the database server. The product monitors at the SQL transaction level end-user response time, data base server response time, network send and receive time, rows returned, SQL transaction errors and more -- by individual user or group of users. Real-time alerts by SQL transaction may be setup. The SQL transaction flow to a database server can be reconstructed from any time period. For high volume (1000+ trans/second) production, datamart, WWW, test and development database server environments. 7x24 Global Sql Monitor for End User and Database Server Service Level Monitoring: ----------------------------- The '7x24 Global Sql Monitor' (powered by the Sql Power SniFFFer) summarizes in real-time the: database server transaction processing rate, average end-user response time, average database server response time, rows returned, network time and more at the SQL transaction level over any specified time interval (e.g. 15 seconds). Database server performance at the SQL transaction level may be determined over any time period for today, yesterday, last week, last month, last quarter or last year. Trending database server performance at the SQL transaction level is immediatrly detected. Hundreds of database servers can be monitored with ZERO impact upon the Informix database servers. Randy Reiter Michael Ivanov wrote in message <3700F102.8C93B430@spb.sterling.ru>... >Hi, does anybody know whether it is it possible to dump a trace of >ALL sql queries, with timing info, >under Informix? > >Thanks a lot >-- >Michael Ivanov. > Voice: +7 (812) 219-9237. E-mail: ivans@spb.sterling.ru > >
Hi Ivanov, Yes it is possible under IDS! But you need an additional product called Informix-Spy or I-Spy. This tool works as a proxy and has some nice features. For additional information visit www.informix.com and have a Quick Search on 'Spy'. hth martin Michael Ivanov schrieb: > > Hi, does anybody know whether it is it possible to dump a trace of > ALL sql queries, with timing info, > under Informix? > > Thanks a lot > -- > Michael Ivanov. > Voice: +7 (812) 219-9237. E-mail: ivans@spb.sterling.ru
Per the emails I received, the following explains the situations under which the Sql Power SniFFFer can or cannot with ZERO required impact - monitor at the SQL transaction level an Informix database server. Please let me know if there are any scenarios I missed. A. The Sql Power SniFFFer or 7x24 Global Monitor products can capture or monitor all or any subset of the SQL transaction performance (or database server service level statistics) sent across a network under the following scenarios: A.1. A connection is made to an Informix database server over the network. The connection can be from a program, end-user, developer or DBA using ODBC, CLI, ESQL, C++, etc. to connect to the Informix database server. Currently DECnet, FDDI, TCP/IP and Token Ring are supported. Other protocols such a Novell can be easily added given market demand. A.2. An end-user, developer or DBA telnets over the network to the platform the Informix database server is running on. Then from the telnet session runs a program such as DBACCESS, etc. to issue SQL to the Informix database server. The connectivity to the Informix database server can be anything. e.g. SHARED MEMORY CONNECTIONS, IPC, ODBC, CLI, ESQL, C++, DECnet, TCP/IP or Token Ring. A.3. LOOPBACK SQL transactions on AIX (available in a few weeks). A loopback SQL transaction is one where the SQL is not sent across the network. e.g. a batch program running on the same platform as the database server connects to the Informix database server using TCP/IP. B. The product line cannot monitor the following situations (at least not yet): B.1. LOOPBACK SQL transactions for Informix database servers running on NT or Solaris . e.g. A batch program running on the same platform as the database server connects to the Informix database server using TCP/IP. The SQL would be sent over the LOOPBACK port to the Informix database server and is not sent over the network. B.2. A batch program running on the same platform as the database server connects to the Informix database server using SHARED MEMORY CONNECTIONS. This scenario is similar to B.1, i.e. LOOPBACK SQL transactions. Note: Please refer to A.2 since the SQL for a SHARED MEMORY CONNECTION is captured and monitored by the Sql Power SniFFFer if the SQL was issued across the network (e.g. telnet session). C. Miscellaneous comments: C.1 The functionality for the monitoring of a SHARED MEMORY CONNECTION when the SQL was issued across the network (e.g. telnet session) will be available next week. C.2 A Sql Power SniFFFer or 7x24 Global Monitor product running on 95, NT, Solaris or AIX can monitor an Informix (IDS) database server running on another operating system (DEC UNIX, i386 UNIX, HP-UX, NCR, SCO UNIX, Stratus, etc.) as long as the product runs on a platform on the same subnet as the database server. i.e. per the above discussion. C.3 The HP-UX version of the product will be available in the near future. Randy Reiter Sql Power Tools www.sqlpower.com 201.825.9511
Thanks for the info. How much does it cost? In article <7drjvf$m8j$1@bgtnsc01.worldnet.att.net>, "Randy Reiter" <rreiter@sqlpower.com> wrote: > Yes - with ZERO database server impact. Refer to www.sqlpower.com. > > Below is a product overview and description of the two Sql Power SniFFFer > products for ZERO impact database (Informix IDS) service level and SQL > transaction performance monitoring. > > 1. '7x24 Global Sql Monitor' for 7x24 ZERO impact end-user and database > server Service Level Monitoring. > > 2. 'Sql Power SniFFFer' for ZERO impact SQL transaction capture, performance > monitoring and alert notification. > > Product Overview: > ================ > > The Sql Power SniFFFer product line non-intrusively analyzes the SQL network > packet flow to the database server for SQL transaction performance > monitoring. The product does NOT have to run on the database server, NOR on > any client workstations connected to the database server. > > The Sql Power SniFFFer products require NO intrusive database server > monitors, agents, probes, audits, middleware or proxy > servers. NO agents are installed on end user workstations. > > The Sql Power SniFFFer products require NO impact upon the database servers, > network or end-users. > > The Sql Power SniFFFer requires NO installation of monitoring middleware, > ODBC, Informix client connectivity software and > MINIMAL on going DBA support. Product installation is a three step process > that can be completed in a few minutes. > > The Sql Power SniFFFer product line is currently available for all versions > of Informix (IDS) database servers. > > Product Line: > ============ > > Sql Power SniFFFer: > ------------------ > > The 'Sql Power SniFFFer' captures, analyzes and monitors the performance of > all SQL transactions to the database server. > The product monitors at the SQL transaction level end-user response time, > data base server response time, network send > and receive time, rows returned, SQL transaction errors and more -- by > individual user or group of users. > > Real-time alerts by SQL transaction may be setup. The SQL transaction flow > to a database server can be reconstructed > from any time period. For high volume (1000+ trans/second) production, > datamart, WWW, test and development database > server environments. > > 7x24 Global Sql Monitor for End User and Database Server > Service Level Monitoring: > ----------------------------- > > The '7x24 Global Sql Monitor' (powered by the Sql Power SniFFFer) summarizes > in real-time the: database server transaction processing rate, average > end-user response time, average database server response time, rows > returned, network time and more at the SQL transaction level over any > specified time interval (e.g. 15 seconds). Database server performance at > the SQL transaction level may be determined over any time period for today, > yesterday, last week, last month, last quarter or last year. Trending > database server performance at the SQL transaction level is immediatrly > detected. Hundreds of database servers can be > monitored with ZERO impact upon the Informix database servers. > > Randy Reiter > > Michael Ivanov wrote in message <3700F102.8C93B430@spb.sterling.ru>... > >Hi, does anybody know whether it is it possible to dump a trace of > >ALL sql queries, with timing info, > >under Informix? > > > >Thanks a lot > >-- > >Michael Ivanov. > > Voice: +7 (812) 219-9237. E-mail: ivans@spb.sterling.ru > > > > > > -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
This is good news, but how much does it cost? In article <370392CC.FA376447@Materna.De>, Martin Berns <Martin.Berns@Materna.De> wrote: > Hi Ivanov, > > Yes it is possible under IDS! > But you need an additional product called Informix-Spy or I-Spy. > This tool works as a proxy and has some nice features. > For additional information visit www.informix.com and have a > Quick Search on 'Spy'. > > hth > martin > > Michael Ivanov schrieb: > > > > Hi, does anybody know whether it is it possible to dump a trace of > > ALL sql queries, with timing info, > > under Informix? > > > > Thanks a lot > > -- > > Michael Ivanov. > > Voice: +7 (812) 219-9237. E-mail: ivans@spb.sterling.ru > -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
jabbar_fagan@my-dejanews.com schrieb: > > This is good news, but how much does it cost? > Don't know the price in dollars, pounds, rubel, yen, ... Why not ask Informix? AFAIK: Informix I-Spy/User 800,- DM (minimum 10 Users/CPU = 8.000,- DM) 410,- Euro (-.- = 4.100,- Euro) 660,- SFR (-.- = 6.600,- SFR) hth martin