Managing FSG Cache
System Usage of FSGCache
Teradata Database file system manages FSG Cache, which is used by:
Teradata Database file system uses FSG Cache for file system segments such as:
Space in FSG Cache
Space in the FSG Cache is not necessarily evenly distributed among AMPs. It is more like a pool of memory; each AMP uses what it needs.
FSG cache contains the most recently used database segments. When Teradata Database needs to read a data block, it checks and reads from cache instead of from disk, whenever possible.
The system performs optimally when FSG Cache is as large as possible, but not so large that not enough memory exists for the database programs, scratch segments, and other operating system programs that run on the node.
Calculating FSG Cache Size Requirements
The FSG Cache percent field controls the percentage of memory to be allocated to FSG Cache. You can change the value in FSG Cache percent using the ctl utility. See the section on setting variables in “Control GDO Editor (ctl)” in Utilities.
First, configure sufficient operating system memory, using the guidelines discussed in “Managing Free Memory” on page 536. Then let the remaining memory be allocated to FSG Cache.
Calculating FSG Cache Read Misses
To calculate if FSG Cache read misses have increased, use the following formulas:
Physical read I/O counts can be obtained from ResUsageSpma table by adding FileAcqReads + FilePreReads.
Logical I/O counts can be obtained from ResUsageSpma table column FileAcqs.
While Teradata Database cannot guarantee a particular improvement in system performance, experience has shown gains of 2-8% when adding 1GB of memory per node in such instances.