Building Baseline Transaction Profiles - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ - Database Administration

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-03
dita:mapPath
tgx1512080410608.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval
dita:id
ujp1472240543947
Product Category
Software
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: