Increasing no of amps will increase performance. Is this
true?

Answers were Sorted based on User's Feedback



Increasing no of amps will increase performance. Is this true?..

Answer / dinesh

hi,

yes ofcourse its increasing performance against when work
load increases, in teradata performance wil not affect
because the work load is evevnly distributed acorss all the
amps.

Is This Answer Correct ?    12 Yes 1 No

Increasing no of amps will increase performance. Is this true?..

Answer / aaa

yes

Is This Answer Correct ?    7 Yes 3 No

Increasing no of amps will increase performance. Is this true?..

Answer / srya

Yes

Is This Answer Correct ?    7 Yes 3 No

Increasing no of amps will increase performance. Is this true?..

Answer / yuvaevergreen

yes...
>>increase the no of amps with same no of users--performance
increases proportionately.
>>increase the no of PEs to increase the no of sessions.
>>increse the no of disks to increase the data storage.

Is This Answer Correct ?    4 Yes 0 No

Increasing no of amps will increase performance. Is this true?..

Answer / himanshu

Yes. But in that case no. of users should be the same. i.e.
suppose there are 5 users requesting 50 MB data, so the no.
of users should not increase. If suddenly 10 users start
demanding the same data, performance would not increase
even if the no. of amps are increased...!!

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More Teradata Interview Questions

How do you load Multiple files to a table by using fastload scripts?

1 Answers   Satyam,


What are two examples of an OLTP environment?

4 Answers  


What is database exceptions in teradata?

0 Answers  


How can we check the version of Teradata that we are using currently?

0 Answers  


What are the enhanced features in teradata v2r5 and v2r6?

0 Answers  






What are tpump utility limitations?

0 Answers  


Why Fload doesn’t support multiset table?

9 Answers  


what is the difference between start schma and Fsldm?

5 Answers   Intel,


Can you load multiple data files for same target table using fastload?

1 Answers  


what is amp plz explanation

5 Answers   IBM,


What is meant by a Virtual Disk?

0 Answers  


any one answer me how they can analyzing the project using data ware housing?

0 Answers  


Categories