Each resource usage foreign table represents system usage data from a specific perspective collected during the logging period. The logging period is a system defined interval of time during which usage data is accumulated (specified in the NominalSecs column in each table). At the end of the logging interval, usage data is written to each of the resource usage foreign tables. Views have been created that are named similarly to the foreign tables in your object storage.
Use resource usage views for these monitoring purposes:
- Analyze disk and CPU usage
- Provide different perspectives on disk utilization
- Check for bottlenecks
- Provide an overall history of the system operation
- Monitor the usage of AMP Worker Tasks (AWTs)
Foreign table definitions and view definitions reside in the td_metric_svc database.
Learn about the data each resource usage view contains:
These views are not documented:
- resusagesmhmV is reserved for future use.
- resusagelpmaV and resusagelvprV are only used by Teradata personnel.