Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 03 Apr 2009 @ 10:28:59 GMT


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


Subj:   Re: PE load distribution
 
From:   DWellman

Hi Inna,

Start by checking the relative number of sessions logged on to each PE.

     SELECT logondate,ifpno,COUNT(*)
     FROM dbc.logonoff
     WHERE event='logon'
     AND logondate >= DATE-20
     GROUP BY 1,2
     ORDER BY 1, 3 DESC,2;

If the sessions are NOT evenly distributed across the PE's on each day then it's probably that a lot of client machines do not have the other PE's listed.

For the sessions that are using that PE, are they running a lot of stored proc's (SPs)? SPs often use a lot of CPU time.

Start with that and see where you get to.


Cheers,

Dave

Ward Analytics Ltd: Information in motion (www.ward-analytics.com)



     
  <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: 27 Dec 2016