Manage FSG Cache | Teradata Vantage - Managing FSG Cache - Advanced SQL Engine - Teradata Database

Database Administration

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

System Usage of FSGCache

The file system manages FSG Cache, which is used by:
  • AMPs on the node
  • Backup activity for AMPs on other nodes
The file system uses FSG Cache for file system segments such as:
  • Permanent data blocks (includes fallback data and SIs)
  • Cylinder Indexes for permanent data blocks
  • Cylinder statistics for Cylinder Read
  • Spool data blocks and Cylinder Indexes for spool
  • WAL space, including Transient Journal (TJ) rows and WAL REDO records
  • Recovery journal rows

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 Vantage 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 Teradata Vantage™ - Database Utilities , B035-1102 .

First, configure sufficient operating system memory, using the guidelines discussed in About Managing Free Memory. 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:
  • FSG Cache read miss = physical read I/O divided by logical read I/O

    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.

  • Increase in FSG Cache misses = FSGCacheReadMissAfter divided by FSGCacheReadMissBefore

While Vantage 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.