CODEWITHSUNDEEP
nodesteradata
logan
logan

Reputation: 8346

How to determine Number of AMPs and Nodes required in Teradata?

One of my company's Teradata Database has 6 Nodes and each node carry 24 AMPs. Could any one please let me know how to determine how many number of AMPs are required per node?

If more AMPs / Nodes are supposed to increase performance, why is it not true to have maximum number of AMPs / Nodes ?

Upvotes: 0

Views: 3028

Answers (1)

dnoeth
dnoeth

Reputation: 60462

The number of AMPs per node is determined by the available CPU and IO.

Usually it's approx. 1 AMP per logical CPU and each AMP has assigned 2*2 mirrored (RAID1) disks (plus eventually a 1/4 of a SSD).

Simply adding AMPs will not improve performance, because you need to add disks, too, and the system is already using 100% resources.

To get more AMPs you add a new node with new CPU/disks.

Upvotes: 2

Related Questions