The key to effective production SQL monitoring is capturing every SQL statement submitted to the database server. Only then can the 10% of the SQL that comprises 90% of the database server activity be pinpointed and analyzed. Sql Power Tool products capture 24x7 ALL end-user SQL with end-user response time, database server response time, network time and much more. Other products that utilize sampling techniques (i.e. the database monitor polls (or reads the database server shared memory) the database instance to see what is running) will miss 90-95% of the SQL submitted to the database server -- plus typically have a 30% database server overhead!

The product line's unique network sniffer architecture allows 100% of the SQL text to be captured, the SQL performance metrics, end-user service level analysis and data warehousing data usage analysis to be performed with zero impact on the database server, network or end-users. No intrusive client agents, middleware, proxy servers, connections to the database server, query of system tables or shared memory reads are required. Database server auditing, tracing or logs are not used (too intrusive). The product does not have to run on the database server host.

Identification of the unique Top N SQL statements requires the SQL to be normalized so that similar SQL statements can be identified, and their end-user service levels reported.

Sql Power Tools can capture every SQL statement both online and offline. This feature allows a user to completely flexible in how and when they monitor the application environment.

The Sql Power Tools product line monitors Informix (7.x and 10.x), Microsoft SQL Server (4.23 to 2005), Oracle (7.x to 10g.x) and Sybase (4.2 to 15.x).

Allows zero impact auditing of all SQL queries, inserts, updates and deletes by end-user (login-id or client IP address), application, host, end-user response time, database server response time, network time, rows returned, error condition, deadlock, SID, SPID, stored procedure, package, table, view, column or key words in SQL text. The products do not require any intrusive database server audits or database server log analysis (note - database log analysis products misses 90% of the SQL statements such as end-user SQL queries).

Conventional database monitors may accrue a 30% overhead for production monitoring making them very expensive to operate. A 30% server overhead may translate into a $100,000+ to 1,000,000+ operating cost per server annually. Conventional database monitors also only monitor 20% of database server problems, and do not proactively identify deteriorating or poor end-user response times (it is never measured). Additionally, convention database monitors are (i) typically intrusive (with nearly 30% overhead), (ii) miss monitoring 98% of the SQL statements (due to ineffective sampling techniques), (iii) do not monitor end-user data usage analysis, and (iv) completely ignore end-user service level analysis.

Conventional database monitors typically cause a 20% to 30% CPU overhead on the database server host being monitored. Usually these monitors are only turned on in production environments when end-users complain about poor response time (the worst time to take an additional performance hit). The Sql Power Tool products (unlike other products) have zero impact upon the database server. The products never connect to the database server, query the internal system tables or read the shared memory of the database server host.

No intrusive client agents, middleware, proxy servers, connections to the database server, query of system tables or shared memory reads are required.

Products can monitor 10,000+ users and 10,000+ transactions a second with NO impact upon the database server, network or end-users.

The average product installation and or product upgrade takes less than 15 minutes!

Contact any of our customers and you will find that Sql Power Tools delivers excellent customer support and is very responsive to customer requested enhancements.