The key metrics to look for include:
- Response time
- Resource utilization
- Data growth, such as number of rows or changes in data demographics (unique values)
- Changes in data access ( insert, delete, update)
- Increases in the number of active sessions (concurrent queries)
- Keeping a record of environmental changes, such as new applications or changes in data loading strategies (node, AMP, cache)
As the saying goes, prevention is better than cure. A monitoring system has its benefits:
- Manage available resources optimally
- Maximize the value of a data warehouse investment
- Extend the life of the current Teradata investment
- Ensure that actions are being taken to meet the service levels that the business needs
- Align client business ...
