Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

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.



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

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023