DBQL Table | Performance Management Information |
---|---|
DBQLogTbl | Data on individual queries, including:
|
DBQLSummaryTbl | A summary of short-running queries. For high-volume queries, it provides query origination, response time summaries, query counts, and CPU and logical I/O usage. |
DBQLStepTbl | Query step timings, CPU and I/O usage, row counts, and step actions, among other things |
DBQLObjTbl | Usage information about database objects such as tables, columns, indexes, and databases. |
DBQLSqlTbl | The complete SQL text. |
DBQLExplainTbl | EXPLAIN output. |
DBQLXMLTbl | Query plans stored in Extensible Markup Language (XML). |