Archives of the TeradataForum

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

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

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>>