Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 09 Jun 2004 @ 13:28:49 GMT

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

Subj:   Re: Session Limits on Loads
From:   Grenwelge, Bill A.

At the sites I have worked at (some very large and some very small). For small systems, anything with less than 100 amps. I would suggest using no more than 32 sessions per job. You could use every session that the system will let you, but for Mloads the multiple session are only good for one phase of the job and that is when the data is being loaded to the work table. After that all the data is on the Teradata system and it doesn't use those sessions anymore at least from what I have observed from watching the jobs via dbcmanager. I have tested on our system which has 56 amps using 56 session and 32 and saw maybe a 3 minute or less difference in run times for the same job. However I did see significant improvement from the original 16 to 32 when we made those changes. One way to determine it would be to set up a test job and try different session counts to find what gives you the balance that your looking for good load speeds but low resource utilization.

Bill Grenwelge
Teradata Certified Master
Data Warehouse - Teradata DBA
Union Planters Bank

  <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