Low Available Free Memory | Teradata Vantage - 17.00 - 17.05 - Adjusting for Low Available Free 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
When the amount of available free memory dips too far below 100 MB (25,000 pages), some sites have experienced issues. 40 MB of free memory is the lowest acceptable amount. You can usually avoid problems if you configure your AMPs to have at least 135 MB of OS-managed memory per AMP. You can adjust the amount of available free memory by performing the following:
  • Use ctl to adjust the FSG Cache percent downward to make more memory available to free memory. If the system takes too much memory for FSG Cache and the OS does not use that memory, the free memory is wasted.
  • If available free memory goes below 100 MB during heavy periods of redistribution (as explained later in this section), lower the value of the RedistBufSize field in the DBS Control Record (see “RedistBufSize” in Teradata Vantage™ - Database Utilities , B035-1102 ).