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:
- Start with a value for FSG Cache percent. See Managing FSG Cache.
- Adjust the value based on available free memory requirements. See Reserving Additional Free Memory for Applications and Managing Free Memory.
- 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.