Zero Impact Sql Transaction Analyzer PRESS RELEASE

From: Mary Owens <mowens_at_sqlpower.com>
Date: Wed, 02 Feb 2000 16:11:52 GMT
Message-ID: <cHYl4.3124$pd2.269252_at_bgtnsc06-news.ops.worldnet.att.net>



Zero Impact Sql Transaction Analyzer PRESS RELEASE:

Sql Power Tools is pleased to announce the Zero Impact Sql Transaction Analyzer product for real-time SQL statement analysis.

This industry breakthru product for DB2, Informix, Microsoft, Oracle and Sybase database servers will provide DBAs, E-Commerce Applications, Administrators, Help Desks and SQL Developers the following crucial information on database server performance at the SQL transaction level:

  1. Identification of the SQL statements that ran most frequently on a database server, with complete SQL text and performance.

   e.g. the top 50 SQL statements/transactions that were executed

        by a production database server 24x7.

2. The complete statistical distribution of all SQL statements

   that ran on a production database server.

3. Both the average performance and service level profile of the SQL

   statements that ran most frequently. Performance statistics provided    by SQL statement include: end-user response time, database server    response time, network times and more at the SQL statement level.

4. All accomplished with ZERO IMPACT upon the production database server,

   network or end-users, since the real-time SQL transactions are    non-intrusively captured with the Zero Impact Sql Monitor product.

Todays complex business systems for E-Commerce, three tier architectures, and client server applications contain thousands of SQL statements developed using rapid application development tools such as Application Servers, C++, Java, Power Builder, and others.

About 80% of database server (and in turn end-user application) performance incidents are related to the performance of the application SQL statements. The remaining 20% are due to high level resource limitations with CPU, memory, I/O and other database configuration issues.

Furthermore - conventional database monitoring products typically only monitor high level system resources, i.e. about 20% of the database server performance incidents!

The Zero Impact Sql Transaction Analyzer (powered by the Zero Impact Sql Monitor) addresses the performance of real-time SQL, i.e 80% of database server performance issue incidents.

BENEFITS:


The Zero Impact product line from Sql Power Tools provides the following business benefits:

  1. The professional staff can focus their SQL performance and tuning efforts on improving the performance of SQL statements that run most frequently in production database servers.
  2. The performance and tuning ROI of application SQL is dramatically improved since the most frequently executed SQL transactions are known.
  3. End-user service levels are improved.
  4. The professional staff can proactively address database performance issues instead of being forced to respond to end-user complaints on a reactive basis.
  5. Product installation is a few minutes. Product is easy to use and requires NO big consulting $$$ for installation and staff training.
  6. The product line's unique architecture requires no intrusive monitors, probes, agents, middleware, database shared memory reads, database server queries, connectivity to the database server or end-users.

AVAILABILITY:


A product license is $2,500 and availability is March, 2000. The Zero Impact Sql Transaction Analyzer requires a license to the Zero Impact Sql Monitor product.

CONTACT INFORMATION:


Contact Sql Power Tools, Inc. at 702.990.3209 or info_at_sqlpower.com. Refer to www.sqlpower.com for product information. Received on Wed Feb 02 2000 - 17:11:52 CET

Original text of this message