Zero Impact Top N Sql Analyzer PRESS RELEASE

Sql Power Tools is pleased to announce the availability of the Zero Impact Top N Sql Analyzer product for real-time SQL analysis.

Scales to thousands of users with ZERO impact on the database server, end-users or network. The product functions as a proactive or predictive database monitor!

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 with the following crucial information on database server performance at the SQL transaction level:

1. Identification of the SQL statements that run most frequently or use the most resources on a database server, with complete SQL text and 24x7 performance profile (by SQL statement).

   Accomplished with ZERO impact upon the database, network or end-users.    Some examples of the product analysis include identification of:

1. The Top N SQL that used the most database server or network resources.

      e.g. SQL that had the largest cumulative end-user response time,
      cumulative database server response time, cumulative network time,
      cumulative rows returned, cumulative transmitted bytes and more.

   b. The Top N SQL statements/transactions that were executed 24x7 most
      frequently by a production, test or development database server.

   c. The Top N SQL with the poorest end-user average or cumulative
      response time, database server response time, network time; or most
      rows returned, transmitted bytes, packets and more.

2. A SQL statement's service level profile over the past 24 hours, week,

   month, etc. can be easily examined.

   e.g. end-user response time (plus database server response time, network    time and more) can be summarized on a one minute (any time period actually)

   basis by individual SQL statement.

3. Alerts immediately identify poor SQL or end-user response time

   at the SQL statement level. Allows trending end-user performance to    be immediately detected.

The product's unique architecture allows a days worth of production SQL to be analyzed in a few minutes. The product does not require the SQL to be loaded to a database for analysis (that may take to long!).

BACKGROUND:

Todays complex business systems for E-Commerce, WWW, 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, Visual Basic and others.

About 80% of database server (and in turn end-user application) performance problems 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. only about 20% of the database server performance problems!

The Zero Impact Top N Sql Analyzer (powered by the Zero Impact Sql Monitor) addresses the performance of real-time SQL, i.e 80% of database server performance issues. The product is a companion product to Zero Impact Service Level Monitor.

BENEFITS:

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

1. The product line functions as a proactive or predictive database monitor since as soon as end-user response time begins to deteriorate it is immediately detected (prior to end-user complaints). Then the performance issue can be dealt with prior to end-users contacting the Help Desk or DBA staff.
2. The professional staff can focus their SQL performance and tuning efforts on improving the performance of SQL statements that use the most resources or run most frequently in production, test and development database servers.
3. The performance and tuning ROI of application SQL is dramatically improved since the longest running and most frequently executed SQL is known.
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, staff training and product operation.
6. The product line's unique architecture requires no intrusive monitors, probes, agents, middleware, database shared memory reads, database server queries, or connectivity to the database server or end-users.
7. Products scale to 10,000+ users and 10,000+ transactions/sec with no required impact on the database server, network or end-users.

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 Mar 08 2000 - 18:04:17 CET