Investigating the Need to Add Memory - 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ā„¢

There is a recommended amount of memory for each Vantage hardware platform. See the Release Definition for your Vantage release for memory recommendations.

You can also monitor the use of FSG cache memory to determine if you should add more memory to assure full performance. See also Managing FSG Cache.

  1. Monitor your system during critical times to determine the ratio of logical to physical I/O.
  2. After the lowering of the FSG cache percent to provide more memory for a memory consuming feature, again monitor your system during critical windows to understand the new ratio of logical to physical I/Os.
  3. If the amount of FSG cache misses increases by more than 20% and the system has become I/O-bound, then adding more memory, if possible, is recommended.