Utility Job Performance Analysis | VantageCloud Lake - Utility Job Performance Analysis and Capacity Planning - Teradata VantageCloud Lake

You can query the DBQL utility job log table, DBC.DBQLUtilityTbl, to analyze the performance of load or export utility jobs and do capacity planning. This table is populated if you use the WITH UTILITYINFO option with a BEGIN/REPLACE QUERY LOGGING request. For details on the contents of the corresponding view QryLogUtility[V], see QryLogUtilityV and Maximum Number of Concurrent FastLoad, MultiLoad, and FastExport Jobs.

You can use DBQLUtilityLogTbl to diagnose utility performance issues and do capacity planning. The following examples show how to use the table.

• Example: Investigating Why a Job Ran Slower Today
• Example: Performance Anomaly Detection
• Example: Capacity Planning