Sql Regression Test, Press Release 
Author Message
 Sql Regression Test, Press Release

FOR IMMEDIATE RELEASE!   January 26, 1996

Sql Power Tools

     Sql Enterprise Regression Test Manager &
           Sql Enterprise Regression Test Analyzer

               products for data base performance analysis &
                 testing are available for Sybase Sql Server

The Development Group for Advanced Technology is pleased to
announce that the Sql Enterprise Regression Test  Manager &
Analyzer products are available for Sybase Sql Server.  These are
the FIRST products in the industry to offer enterprise based data
base performance analysis and regression testing of Sql Server at
the Sql statement level.  ONLY Sql Power Tools allow the
performance of System 11 to be compared to prior releases of
Sybase at the Sql statement level (Show Plan, I/O Statistics and
Cost Based Optimizer results) before application deployment.  

With the Sql Power Tools product suite you will know to the Sql
statement and stored procedure level the difference in data base
performance between system releases, application turnovers and
changing production data base data distributions.  Unlike other
client based regression test products, ONLY Sql Power Tools
provides data base oriented performance analysis and regression
testing products!

The Sql Enterprise Regression Test Manager allows test suites of
data base transactions with statistically sampled test data to be
automatically designed, constructed, replayed, archived and run
for automated regression testing across data base servers.  Test
suites can be automatically constructed from PowerBuilder trace
logs, ODBC driver trace logs, Open Server trace logs -- or based
upon SQL statement or stored procedure definitions, performance
profiles, relationships, dependencies, Show Plan, I/O Statistics or
Cost Based Optimizer results.

The Sql Enterprise Regression Test Analyzer compares and
presents the results of data base performance regression tests to
the Sql statement, stored procedure or data base transaction level
by release, server, data base or time period.  This allows
differences in data base performance (Show Plan, I/O Statistics,
Cost Based Optimizer results) at the SQL statement level to be
easily identified.  Stored procedures or Sql statements exhibiting
degrading performance over time may be immediately detected.
Performance differences between Sybase release 4.9, 10 and 11 at
the Sql statement, stored procedure or data base transaction level
are identified, reported and graphed.

The products automatically locate SQL statements in
PowerBuilder trace logs, ODBC driver trace logs, Open Server
trace logs, dynamic SQL, stored procedures and triggers, then
performs replay or global Show Plan and I/O Statistics analysis.
All Cost Based Optimizer Sql statement evaluations are reverse
engineered and analyzed under global conditions.  All results are
presented in powerful Index Coverage, Show Plan and I/O
Statistics Browsers that allow performance problems to be easily
identified.  Comprehensive graphical analysis of all results are
presented, summarized and explained in structured English.

Any server, data base or any subset of the data base dynamic
SQL, stored procedures and triggers may be analyzed with these
products.  One does not have to waste time manually selecting
SQL statement text and constructing test data in order to perform
comprehensive data base performance analysis.  Sql Power Tools
are not limited to only replay of captured data base activity.
Global analysis of all Sql statements may be immediately
performed with statistically sampled data that typically provides
more robust performance analysis than trace logs or captured data
base activity.

The Enterprise Regression Test Manager & Analyzer products
will assist SQL developers, DBAs, development teams, quality
assurance, regression testing, performance analysis and turnover
activities in delivering more predictable performing client server
data base applications.  Data base performance to the SQL
statement level can now be determined prior to deployment.  Sql
Power Tools significantly reduces implementation risk when
deploying client server applications.

Whether you have 1 or 100 data base servers, data bases or
applications, 50 or 5,000 stored procedures, 50 or 50,000 SQL
statements that require a consistent and high level of data base
performance to be delivered, Sql Power Tools is invaluable.  A
development team, Sql developer, DBA or quality assurance
group can easily analyze 50,000 SQL statement, stored
procedures or triggers daily across all data base servers and
identify SQL statements or stored procedures not coded for
optimal data base performance.

Sql Power Tools can be installed in 10 minutes, and within 30
minutes tell you more about the performance of your data base
Sql than person months of manual analysis could reveal!  These
products are available for HP-UX, IBM RS/6000, Sun OS, Sun
Solaris, Windows 3.1, Windows 3.11 and Windows NT.  

The Development Group for Advanced Technology
12 Barnfield Court
Upper Saddle River, NJ
07459 USA


Visit us on the World Wide Web at http://www.***.com/
learn more about these and the Sql Power Plan Analyzer, Sql
Power I/O Statistics Analyzer and Sql Index Coverage Analyzer
products.



Fri, 17 Jul 1998 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Sql Power Regression Test Server PRESS RELEASE

2. Performance Regression Testing PRESS RELEASE

3. URGENT PRESS RELEASE URGENT PRESS RELEASE

4. --->>PRESS RELEASE PRESS RELEASE

5. PRESS RELEASE: INFORMIX, HEWLETT-PACKARD TO BUILD PERFORMANCE TESTING LAB

6. Regression tests failing on abstime due to test date being

7. Another regression test fails to stand the test of time

8. PRESS RELEASE: Xceed Zip Compression Library released

9. Recent Press Release: Developer/2000 Release 1.2

10. Recent Press Release: Developer/2000 Release 1.2

11. Recent Press Release: Developer/2000 Release 1.2

12. Recent Press Release: Developer/2000 Release 1.2


 
Powered by phpBB® Forum Software