Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 08 Jul 2002 @ 20:41:06 GMT


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


Subj:   Virtual Amp question
 
From:   Anomy Anom

<-- Anonymously Posted: Monday, July 08, 2002 16:01 -->

My shop is OLTP.

On the 3600 hardware, where the amps were pieces of hardware, we use to experience hot-amps because of the choice of the 'not unique enough' primary index that caused poor data distribution. Then by the nature of the OLTP application, many processes would be try to get at the data on the same amp. Thus the hot-amp situation occurred.

On the newer hardware (i.e.4855), the amps are software, not hardware. So does the software manage the hot-amp situation? If an amp is getting too busy, does some of the work get sent to other amps? Or is it possible to still see a hot-amp situation?

Thanks.



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016