Using Data Resource Usage Macros and Tables
Teradata Vantage™ - Resource Usage Macros and Tables describes Teradata macros that can be used to report resource usage data and, when enabled, the tables that can be used to:
- Observe the balance of disk and CPU usage
- Obtain pdisk usage information
- Check for bottlenecks
- Provide an overall history of the system operation
- Monitor the utilization of AMP Worker Tasks (AWTs)
Why Would I Use this Content?
This content is intended to be used by persons responsible to administer or manage a database.
How Do I Get Started?
Familiarize yourself with the macros and tables to determine what meets your needs and go to the related content.
References to Other Relevant Content
For general information:
- Collecting RSS data, see Teradata Vantage™ - Application Programming Reference, B035-1090.
- Changes in the resource tables, views, or macros between database releases, see Resource Porting Usage Guide, B035-1183.
For information on workload management (WM) capacity on demand (COD) and setting limits on resource usage:
- Workload Management Capacity on Demand and Other Hard Limits Orange Book, TDN0009761
- Teradata® Integrated Workload Management Teradata SLES 11 Orange Book, TDN0001728
- Teradata® Viewpoint User Guide, B035-2206