Loading Events

Nov 23 / 2023 / 3:00 pm - 4:00 pm CET

SQL Quality Control

SQL Quality ControlJoin our webinar SQLQC: Efficient Tuning Large Workloads on November 23 where we will demonstrate how our product SQLQC can analyze your current Db2 workload and recommend ways to improve it.

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 the 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.

This webinar on November 23rd at 3 pm Central European Time covers:

  • Analyze the behavior of SQL over time (CPU, elapsed time, IO, etc.)
  • Overview of all executed SQL over a given period
  • Recognition of SQL access path changes over several months
  • SQL grouping of statements with the same pattern
  • Cost estimator statistics (incl. history)
  • Automated index proposals
  • Table quiet time (when is a table not used )
  • Unused indexes (indexes with overhead for insert, but not used in select)

REGISTER FOR WEBINAR

 

Webinar