Resource utilization statistics are stored in tables in Advanced SQL Engine. You can access these tables by using Teradata Studio or DBQL.
| Table Name | Description |
|---|---|
| td_mle_db.QueryLog | Contains query level statistics by global Teradata Vantage ID. |
| td_mle_db.QueryLogSQL | Contains query level error and text summary for ML Engine. |
| td_mle_db.ResUsageNetwork | Contains system level statistics for ML Engine network usage. |
| td_mle_db.ResUsageCpu | Contains system level statistics for ML Engine CPU usage. |
| td_mle_db.ResUsageDisk | This table is created but currently does not contain data. |
| td_mle_db.ResUsageMemory | Contains system level statistics for ML Engine memory usage. |
See System Monitoring.
If stats movement is disabled, these tables will be empty:
- td_mle_db.ResUsageNetwork
- td_mle_db.ResUsageCpu
- td_mle_db.ResUsageMemory
- td_mle_db.ResUsageDisk