Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 10 Jun 2002 @ 00:42:11 GMT


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


Subj:   Query on sessions and teradata handling queries in parallel
 
From:   Narayan Murthy K S

Hi all,

I have a question on session handling and teradata handling queries in parallel.

Suppose i have a machine configured with 2 PEs and 4 AMPs. Now i have 4 bteq scripts which contain sql statements. Now we know that each PE is capable of handling 120 sessions. With this what happens when:

1. I fire all the 4 bteq scripts together in parallel(4 sessions). Will the PEs share the load or will it go to a single PE(because a single PE can handle upto 120 sessions) with the other PE remaining idle.

2. Will the performance(or the time taken) to execute all the 4 bteq scripts be less with both the PEs in action when compared to a single PE handling all the 4 bteq scripts.


Thanks

Narayan Murthy.



     
  <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