DQBL tables – Performance data collection

You can use DBQL tables to collect and evaluate:
• System throughput
• Response time
• Query details, such a query step level detail, request source, SQL, answer size, rejected
queries, resource consumption
• Objects accessed by the query

In addition to being able to capture the entire SQL statement, regardless of the length of the
SQL, DBQL also provides key insights into other aspects of a query such as whether it was
aborted, delayed by Teradata DWM, the start and end time, and so on.

DBQL operates asynchronously. As a result, the logging activity has a much lower impact on
the overall response time of given transactions.