16.10 - Building Baseline Transaction Profiles - Teradata Database

Teradata Database Administration

Teradata Database
Release Number
Release Date
April 2018
Content Type
Publication ID
English (United States)

Baseline profiles can provide information on typical resource usage by period and by user, on a daily, weekly, or monthly basis. Building baseline transaction profiles can help you track the effects of software upgrades, introductions of new users or new applications, and help you determine what a “healthy and normal” system should look 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: