Archives of the TeradataForum
Message Posted: Fri, 03 Apr 2009 @ 10:28:59 GMT
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 )
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|