Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 22 Nov 2002 @ 17:59:36 GMT


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


Subj:   Re: Sessions vs AMPs vs Data
 
From:   Matthew Winter

Hi,

Based on our experience with FastLoads, and attempting to maximise the performance bu minimise the number of sessions, I calculated a formula to work out the number of sessions a FastLoad script should use.

1. Calculate the number of records contained within a message (64K Block). This is output as part of the FastLoad logs. Call this value RM.

2. Calculate the average number of records for a single load. Call this value AR.

3. Calculate the average number of message blocks required to be transferred. Call this value AM, which is calculated as ROUNDUP(AR / RM, 0) within Excel.

4. NM = Number of AMPs on your system.

5. IF ((AM / 100) is less than NM) THEN Number of Sessions = AM / 100 ELSE Number of Sessions = NM

I hope you find the above useful.


Regards

Matthew Winter

Technical Architect
TPG IS Design Authority
Teradata Certified Professional



     
  <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: 15 Jun 2023