|
Efficiently
written SQL code means efficient CPU usage, improved response
time, reduced I/O activity and reduced resource locking. SQL
PerformanceExpert (SPX) assures best SQL performance from
the beginning. It assists in writing SQL, streamlines QA and
even identifies performance bottlenecks in production.
SPX
analyzes SQL performance and identifies DB2 SQL tuning changes
that improve application performance, pinpointing problem
areas and saving time and money associated with inefficient
applications.
SPX
improves application performance and developer productivity
with the following features:
- Uses
itelligent analysis and continuous monitoring to identify
SQL statements that can hinder application performance
- Reduces
I/O activity and resource locking
- Checks
new/changed SQL against production data
- Identifies
and eliminates unnecessary package versions
- Simulates
production-level SQL access paths that are generated by
the rebind process
- Compares
SQL statements from different source versions for best performance
- Offers
the right interface and function for
- Developers
- QA
staff
- production
DBAs
|
|
|
Product
Description
|
| |
|
| |
Product
Benefits
|
- Automate
analysis and SQL tuning
- Support
static and dynamic SQL
- Increase
QA productivity and reliability by automating SQL
analysis
- Interactive
SQL workbench integrated into your (ISPF) editor
- Ensure
good SQL programming practices with an expert system
of over 600 DB2 version specific rules and conditions
- Iterative
method easily fits into existing development and QA
processes
- Obtain
informative, automated reports on SQL
- Allows
implementation of SQL rules that enforce in-house
coding standards
- Seamlessly
integrates into existing quality assurance procedures
and change control systems
- Create
production baselines for easy testing and QA
|
|
