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)
- Drill down into DBQL after targeting workloads using:
Use this resource... | To identify details about... |
---|---|
AMPUsage | Top consumers |
Spool Log | High spool users |