Investigating the Need to Add Memory - Teradata Database

Teradata Database Administration

Teradata Database
Release Number
English (United States)
Last Update
Product Category

Investigating the Need to Add Memory

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” on page 538.

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.