Baseline Transaction Profiles | Teradata Vantage - 17.00 - 17.05 - Building Baseline Transaction Profiles - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
rgu1556127906220.ditamap
dita:ditavalPath
lze1555437562152.ditaval

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: