SQL Tuning and Testing Software

SQLab Xpert is a testing and tuning tool that is designed to identify offensive SQL statements and provide context-sensitive tuning advice. Users can test the tuning advice against their test or production environment to compare the suggested tuning scenarios and choose the suggestion that best fits their environment.

Features of the software include:

• Facilitates both proactive tuning in the development phase and reactive tuning for production systems
• Identifies offensive SQL statements at the root of performance problems
• Integrates with Oracle Applications and PeopleSoft to enable DBAs to identify what user and/or application is associated with offensive SQL statements
  
• Collects and stores the worst performing SQL
• Comprehensive tuning lab provides all information on a selected statement
• Offers expert tuning advice developed by the developer's Oracle experts
• Enhanced TKPROF-style trace statistics show how many rows were actually processed versus what Oracle estimated

The manufacturer states that proactive tuning at the development phase can ensure that applications will operate at peak performance before going to production. In addition, reactive tuning can help to quickly locate offensive SQL in the production environment and resolve performance problems before end users are affected further.

Quest Software Inc, 8001 Irvine Center Drive, Irvine, CA 92618. TeL; 949-754-8000. Fax: 949-754-8999.