Example: How to Analyze Cell Usage Optimization - Teradata Director Program

Teradata® Director Program Reference - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Director Program
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-11-17
dita:mapPath
cki1641301536147.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
frc1470439950465
Product Category
Teradata Tools and Utilities

For the purpose of this example, assume the following things:

  • A system with 8 CPs, 8 SPs and 100 AMPs
  • 5 FastLoads running using 100 sessions
  • 5 BulkLoads running using 100 sessions
  • Each FastLoad or BulkLoad request is 32K (this produces approximately 33 992 byte cells, for a total of 31 Mbytes)
  • System is running with the default initial cell values, resulting in a TDP0021 message indicating exhaustion of 992 byte cells or a TDP0202 message indicating exhaustion of XMS cells.
  • 10% of the sessions have requests in transit through TDP simultaneously at any given moment.