Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 12 Jan 2001 @ 10:23:37 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Performance/Power
From:   David Wellman


I'm not certain you'll get any really sensible answers for this. As you say there is more than just cpu power, it will also be affected by number of nodes, disk config, memory, virtual configuration, channel/lan connects and (last but not least) the work load that your running. It is probably this last factor which provides the most cause of variation. If you have a heavy disk i/o workload then the difference in Node cpu power is less important. Having said that, for a 4700 to 4800 jump you've got a lot more i/o throughput capability in the node. On one machine migration that I worked on (albeit with different node types involved) we saw comparitive speed-up of between 1 and 12-15 times, so it is very variable.

If you want to compare two machines, try using the portion of a query that only uses Teradata resources. An Insert/Select, Update, Delete etc or maybe use a normal Select statement but ignore the response phase. I wouldn't use any of the load/unload utilities by themselves as they can be heavily dependent on host resources.



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