Use Memory Effectively | Teradata Vantage - 17.00 - 17.05 - Using Memory Effectively - 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

Regardless of the amount of available memory on your system, you need to use it effectively. To determine if your system is using memory effectively:

  1. Start with a value for FSG Cache percent. See Managing FSG Cache.
  2. Adjust the value based on available free memory requirements. See Reserving Additional Free Memory for Applications and About Managing Free Memory.
  3. Consider adjusting other memory-related settings to optimize database function.
    • DBSCacheThr
    • DictionaryCacheSize
    • HTMemAlloc
    • IdCol Batch Size
    • PPICacheThrP
    • RedistBufSize
    • SyncScanCacheThr

For information on how to adjust DBS Control memory settings, see Teradata Vantage™ - Database Utilities , B035-1102 .