Evaluating Peak Utilization Periods - 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
Language
English (United States)
Last Update
2023-11-03
dita:mapPath
pgf1628096104492.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ujp1472240543947
lifecycle
latest
Product Category
Teradata Vantage™

Once you have identified the peak period, you can look for the bottleneck. Examining ResUsage data is one technique helpful in finding bottlenecks.

Some possible bottlenecks are:
  • CPU saturation
  • Disk saturation
  • Free and/or FSG cache memory
  • BYNET
  • Vprocs (hot AMPs, coexistence, load balancing)
  • Channel (number of sessions or channel speed)
  • LAN/gateway (number of sessions or network connections)
  • Lock contention

Resource Usage by Workload

ResSpsView, a view of the ResUsageSps table, allows you to see the percentage of CPU used by different workloads, determine which workload is responsible for I/O skew, and examine queue wait time and service time numbers to find backed up queries.

For ResUsageSps table column definitions, see Teradata Vantage™ - Resource Usage Macros and Tables, B035-1099.