16.10 - Using DBQL Tables - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
16.10
Release Date
April 2018
Content Type
Administration
Publication ID
B035-1093-161K
Language
English (United States)

You can use DBQL tables to collect and evaluate:

  • System throughput
  • Response time
  • Query details, such as query step level detail, request source, SQL, answer size, rejected queries, resource consumption
  • Objects accessed by the query

Such information enables you to:

  • Identify a workload that does not meet response time Service Level Goals (SLGs)
  • Drill down into DBQL after targeting workloads using:
This resource... To identify details about...
AMPUsage Top consumers
Spool Log High spool users