Baseline Transaction Profiles | Teradata Vantage - Building Baseline Transaction Profiles - Analytics Database - Teradata Vantage

Database Administration

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-10-04
dita:mapPath
pgf1628096104492.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ujp1472240543947
lifecycle
latest
Product Category
Teradata Vantage™

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: