|
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 |
| |
SolutionShowcase HUK 2009 |
| |
SolutionShowcase HUK 2005 |
| |
|
| |
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
|
|
