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.
Join our Newsletter