SQLQC / Efficient SQL Tuning of Large Workloads

SQLQC Logo

SQLQC analyzes the current Db2 workload and offers suggestions for improvement

Increasingly complex workloads require new methods for SQL quality control and performance tuning. Numerous different SQL statements are continuously being funneled through the systems. This makes it difficult to decide which SQL statements have potential for optimization and if the use of resources is justified. SQLQC stands for SQL Quality Control and is designed to address these new challenges.

Anyone familiar with SQL tuning knows the dilemma: A new index might accelerate one of the queries, but the impact on the total SQL remains unknown. Even harder to evaluate is the deletion of supposedly needless indices. Considering the amount of workloads nowadays, such  analysis can hardly be handled manually.

How does the deletion or insertion of an index impact the overall system? Is the CPU consumption of the workload increasing or decreasing? These questions can be answered with the index advisor without the need of actually generating the indices. You can simulate the recommendations of the index advisor immediately to analyze the impact on a single statement or on the entire environment.

SQLQC is a tuning tool that not only helps the DBA in his daily work, but is also of interest for application developers. SQLQC helps application developers examine the quality of their SQL statements.

It provides an overview of all executed SQL over a given period of time in order to map/ to show the behavior of SQL over time (CPU, elapsed time, IO, etc.). Changes in the SQL access path are being recognized even if several months have passed. There is no extra overhead, the collection of data is not dependent on costly traces. Additionally, Class 3 (wait times) are monitored for each SQL.

SQLQC analyzes thousands of SQL statements and groups those with the same pattern to guarantee that even short, fast SQL are being considered in the process of optimization.

The graphical workstation shows and organizes all relevant information. It comes with a zoom feature to ease the evaluation of relations. Resource efficient and adhoc, the user can identify which tables are being accessed by which SQLs.

The automated and ongoing reviews of static and dynamic statements of the different SQL environments distinguish SQLQC from other performance monitors. The tool frees up specialists from tedious work, saves them laborious analysis of performance traces, statistics, index inspections, etc. Complex questions and hidden problems are answered by just a mouse-click for application programmers and database administrators in ensuring quality assurance in all development and rollout cycles as well as for ongoing supervision of production.
  • Analyze the behavior of SQL over
    time (CPU, elapsed time, IO,…)

 

  • Overview of all executed SQL
    over a given period of time

 

  • Recognition of SQL access path
    changes over several months
  • Class 3 (wait times) are monitored
    for each SQL

 

  • Cost-effective data pooling
    without traces