Using DBQL Tables - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
Product Category
Software

Using DBQL Tables

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