You can use DBQL tables to collect and evaluate:
- System throughput
- Response time
- Query details, such as step information, request source, SQL, answer size, rejected queries, resource consumption, and the number of rows inserted, updated, and deleted
- Objects accessed by the query
Such information enables you to:
- Identify a workload that does not meet response time Service Level Goals (SLGs)
- Get additional details in DBQL after targeting workloads using:
| Resource | Description |
|---|---|
| AMPUsage | Identifies details about top consumers |
| Spool Log | Identifies details about high spool users |