SQL Optimizer improves DB2 UDB performance.

Quest SQL Optirmizer for DB2 UDB is based on technology developed by the SQL tuning experts at LECCOTECH, which was recently acquired by Quest Software. Quest SQL Optimizer for DB2 UDB is a performance optimisation tool that reduces the risk of downtime and improves user satisfaction by automating the process of proactively identifying and resolving SQL operational issues affecting database applications.

Comment:

With growing data volumes, an increasing number of databases, and enhanced SLAs, managing databases is becoming even more resource-intensive and requires greater planning, (Forrester Research. July 2004 report, DBMS: Foundation Of Application infrastructure)

Enterprises must focus on formalising database management through planning, standardisation, and best practice adoption to improve operational efficiency and lower costs. These include automating administrative tasks, standardising DBMSes, formalising administrative processes and procedures, performing database consolidation, and cdoreing strong security measures.

IT managers are under increasing pressure to ensure the availability and performance of business-critical applications. SQL performance problems are difficult to locate and are often not realised until after the quality assurance phase of application development. This can lead to business application and process slow downs, service-level agreements not met and internal and external customer satisfaction issues. Quest SQL Optimizer for DB2 UDB addresses these issues by offering complete SQL performance optimisation with proactive problematic SQL detection, automated SQL optimisation and benchmarking capabilities to maximise operational efficiency and improve scalability.

www.quest.com