Teradata Viewpoint uses a
sample rate to collect data from the system and uses a retention policy to keep the
collected data for a time period or up to a certain size. The sample rate and retention
policy vary for each data collector and most can be adjusted as needed.
Not applicable under the Initial Retention Policy column indicates that data collector does not store data.
Teradata Data Collectors
| Data Collector | Recommended Sample Rate | Initial Retention Policy |
|---|---|---|
| Account Info | 12 hours | 1 week |
| Alert Request | 5 minutes | Not applicable |
| AWT Info | 60 seconds | 1 year |
| Database Space | 1 day | 10 GB |
| Dictionary | 1 hour | Not applicable |
| Disk Space | 1 hour | 1 year |
| Elastic Limit | 60 seconds | 1 year |
| Elastic Usage | 1 hour | 1 year |
| Lock Info | 1 hour | 10 GB |
| Query Count | DBQLFlushRate value from the DBS Control utility display command, otherwise 1 hour | 10 GB |
| Query Log | Within an hour after the PDCR daily job completes | 2 years for summary data 14 days for detail data |
| Resource Usage | Node/Vproc logging rate as set in Monitor Rates, otherwise 1 hour | 10 GB |
| Sessions | Session sampling rate as set in Monitor Rates, otherwise 30 seconds | 10 GB |
| Stats Manager | 1 hour | 3 months |
| System Config | 12 hours | 1 week |
| System Stats | Node/vproc collection as set in Monitor Rates, otherwise 30 seconds | 1 year |
| Table Space | 1 day | 10 GB |
| TASM Config | 10 minutes | None (both disabled) |
| TASM Distribution | 60 seconds | 1 year |
| TASM Exception | Sample rate returned by PM/API TDWM Summary, otherwise 60 seconds | 1 year |
| TASM State | 60 seconds | 1 year |
| TASM Summary | Sample rate returned by PM/API TDWM Summary, otherwise 60 seconds | 1 year |
| Virtual Storage | 12 hours | 1 year |
Aster Data Collectors
| Data Collector | Recommended Sample Rate | Initial Retention Policy |
|---|---|---|
| Cluster Status | 10 seconds | 1 year |
| Component Stats | 30 seconds | 1 year |
| Nodes | 5 minutes | 1 year |
| Processes | 10 seconds | 10 GB |
| Rulesets (Database 15.0 and later) | 10 minutes | Not applicable |
| Space Usage | 1 day | 10 GB |
| System Config | 12 hours | 10 GB |
| Workloads | 1 hour | 1 year |
Teradata Machine Learning Engine Data Collectors
| MLE Data Collector | Recommended Sample Rate | Initial Retention Policy |
|---|---|---|
| Cluster Status | 10 seconds | 1 year |
| Component Stats | 60 seconds | 1 year |
| Pods | 300 seconds | 1 year |
| Processes | 60 seconds | 10 GB |
| System Config | 12 hours | 10 GB |
Teradata Hadoop Data Collectors
The range of allowed values for the sample rate of the Hadoop data collectors are 15-3600 seconds.
| Data Collector | Recommended Sample Rate | Initial Retention Policy |
|---|---|---|
| HBase | 60 seconds | 1 year |
| HDFS | 60 seconds | 10 GB |
| MapReduce (HDP 1.3) | 60 seconds | 10 GB |
| Services | 60 seconds | 10 GB |
| System Config | 5 minutes | Not applicable |
| System Stats | 60 seconds | 10 GB |
| YARN (CDH and HDP 2.1 and later) | 60 seconds | 10 GB |
Teradata QueryGrid Data Collectors
| Data Collector | Recommended Sample Rate | Initial Retention Policy |
|---|---|---|
| Issues | 30 seconds | 1 year or 10 GB |
| Queries | Query summary frequency as set in Managers > Settings in the QueryGrid portlet, otherwise 30 seconds | 1 year or 10 GB |
| System Config | 12 hours | Not applicable |