 |
|
|
|
 |
NEON SQL PerformanceExpert:SQL Tuning |
|
|
SQL PerformanceExpert®
 Well-tuned SQL statements mean efficient CPU usage, improved response time, reduced I/O activity and reduced resource locking. SQL PerformanceExpert for DB2 on z/OS 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.
SQL PerformanceExpert improves application performance and developer productivity with the following features:
 |
|
| • |
Uses intelligent analysis and continuous
monitoring to identify SQL statements that can hinder application performance. |
|
|
| • |
Reduces I/O activity and resource
locking. |
|
|
| • |
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. |
|
|
Product Benefits
|
|
| • |
Automate analysis and SQL tuning |
|
|
| • |
Increase application performance and
stability |
|
|
| • |
Increase QA productivity and reliability
by reducing retesting needs |
|
|
| • |
Increase programmer productivity by
automating SQL analysis |
|
|
| • |
Ensure good SQL programming practices
with an expert system of over 600 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 exisiting quality assurance procedures and change control systems |
|
|
|
|
