 |
 |
Archives of the TeradataForum
Message Posted: Wed, 09 Jun 2004 @ 13:28:49 GMT
| 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
| |
