Baseline profiles provide information on typical resource usage by period and by user, on a daily, weekly, or monthly basis. Building baseline transaction profiles helps you track the effects of software upgrades and introductions of new users or new applications, and helps you determine what a "healthy and normal" system looks like.
You can build baseline profiles for:
- Single operations (such as FastLoad, full table scans, primary index INSERT ... SELECTs, select joins, and so on.)
- Multiple, concurrently run transactions
Once defined and stored, baseline profiles can help you:
- Compare current to profiled operations on a real-time basis.
- Collect data instantaneously for a set interval.
- Detect and resolve throughput anomalies.
You can gather performance metrics for profiling from: