16.10 - Investigating the Need to Add Memory - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
16.10
Release Date
April 2018
Content Type
Administration
Publication ID
B035-1093-161K
Language
English (United States)

There is a recommended amount of memory for each Teradata Database hardware platform. See the Release Definition for your Teradata Database 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.