1.1 - Output Storage - Teradata Vantage

Teradata Vantageā„¢ User Guide

prodname
Teradata Vantage
vrm_release
1.1
created_date
May 2020
category
User Guide
featnum
B700-4002-079K

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