This section describes how to:
- Track query behavior by using Database Query Logging (DBQL)
- Maintain DBQL logs
- Shred the lock plan information in the XML Lock Log table, DBQLXMLLockTbl
For information on performance and resource monitoring for the database, see Monitoring Performance and Resource Usage .
- DBQL Overview
- Rules Validation
- SQL Logging Statements
- SQL Logging Considerations
- SQL Logging by Workload Type
- SQL Statements to Control Logging
- DBQL Macros
- DBQL Tables
- DBQL Views
- Shredding the Lock Plan Information in the XML Lock Log Table, DBQLXMLLockTbl
- Query Data Storage and Protection
- Things to Consider When Logging DBQL Data
- Logging Scenarios
- Example: OBJECT Data for One Query
- Example: STEP Data for One Query
- Examining the Logged Data
- Maintaining the Logs
- Reviewing or Ending Current Rules
- Granting DBQL Administrative Privileges to Other Users