17.00 - 17.05 - Investigating the Need to Add Memory - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
rgu1556127906220.ditamap
dita:ditavalPath
lze1555437562152.ditaval

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.