Shared Memory | Teradata Vantage - Shared Memory - Analytics Database - Teradata Vantage

Database Administration

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-11-03
dita:mapPath
pgf1628096104492.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ujp1472240543947
lifecycle
latest
Product Category
Teradata Vantage™

The system determines how memory is shared between the OS and FSGCache. For example, the following figure illustrates how the system calculates FSG Cache for a system with 16 GB shared memory.


Calculating FSG cache

When Linux boots, PDE:
  • Determines how much memory the OS is already using.

    In the example, memory is shown to be 500 MB. This number may vary depending on the system configuration.

  • Leaves to the OS an amount of memory equal to the number of vprocs times the memory allocated to each vproc.

    In the example, this amount is 90 MB for each of the 28 vprocs.

    Vprocs include AMPs, PEs, the Gateway, and the Node vproc.
  • Calculates the FSG Cache by (1) subtracting the OS-managed memory from total memory size and then (2) applying a FSG Cache% to that amount.
    To calculate the FSG Cache per AMP, divide the FSG Cache by the number of AMPs.

    The amount of OS-managed memory is 3020 MB and the FSG Cache, if the FSG Cache% is 100%, would be 13364 MB.

    If the FSG Cache% were set to 65%, then the FSG Cache would be 8687 MB, and the additional free memory would be 13364 MB minus 8687 MB, or 4677 MB.

    If you want to run applications with memory requirements unknown to Vantage software, reduce the FSG Cache% to leave memory for the applications.

    FSG Cache is managed in multiples of 4 KB up to 128 KB, and then in increments of 256 KB, 512 KB, and 1 MB.

Reserving Additional Free Memory for Applications

To reserve 20% of the FSG Cache for applications over and above the 90 MB/vproc reserved for the OS, go to the DBS screen and set FSG Cache percent to 80. The system assigns 80% of the FSG Cache to FSG and leaves the remaining 20% for other applications.

For information on ctl, see Teradata Vantage™ - Database Utilities, B035-1102.