Adding 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™

When you add memory, you increase cache to maximize the capability of the CPUs. This is helpful when CPUs are processing faster than the disk contents can be read into memory (that is, when the system is I/O-bound).

The following table lists reasons to add more memory.

Condition Description
Add vprocs to existing nodes Each vproc consumes 32 MB of memory. When you add vprocs to existing nodes, you probably should add memory.

Additional vprocs can substantially reduce free memory, which can cause more I/Os because the system can cache fewer datablocks.

Excessive paging/swapping (thrashing) More memory means that more code and data can be cached, achieving less I/O for paging and swapping.
Tables in memory Increased memory may reduce I/O by accommodating:
  • Tables that are currently too large to remain in memory during processing
  • More small tables concurrently residing in memory during processing

I/O can be affected by the size of data blocks. See the DATABLOCKSIZE option for the CREATE TABLE statement in Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.