Use Memory Effectively | Teradata Vantage - Using Memory Effectively - Advanced SQL Engine - Teradata Database

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.