Performance Lifecycle
Data warehouse performance management is not a one-off isolated activity; it is a continuous cycle of –
- Setting objectives
- Gathering data
- Analysing the data
- Actions based on the Analysis
- Reviewing the results of the actions and restarting the cycle
Ward’s comprehensive suite of software solutions support all aspects of the Performance Lifecycle, and are tailored specifically to provide maximum value to Teradata data warehouses. Areas that can be addressed by the deployment of Ward’s in support of the Performance Lifecycle can include;
- Missed SLA’s
- Performance Degradations
- Random Performance Hits
- Poorly Performing Queries
- Real-Time Workload Performance
- Multi-Temperature Data Management Issues
Different products support different elements of the Lifecycle;
| Product | Lifecycle Stage | ||||
|---|---|---|---|---|---|
| Set Objectives | Gather Data | Analyse | Take Action | Review | |
| PHD |  |
|
|
||
| Visual Edge | |
|
|
|
|
| SLAM | |
|
|
|
|
| Prism | |
||||
| HeatSeeker | |
|
|
|
|
| AWM | |
|
|
|
|