Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 18 Oct 2001 @ 21:35:18 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: PMON Fields
From:   Steve Hummel

Fred is correct. In addition, the Teradata Manager 5.0 Performance Monitor and Session Information reports show you information about the "skewedness" of sessions to identify those that are problematic.

You can also set up Teradata Manager's Alerts facility to notify you (email, pager, etc.) when parallel effiency of nodes or amps declines to specified thresholds, or when the CPU skew % of a session reaches a critical level. You can then drill down to identify the problem session(s), the SQL and Explain plans associated with those sessions, and then abort them, or change their priority as needed. These new features should give you more proactive ways to manage your systems.

As Fred mentions below, some of these features require the V2R4.1 release of the database, with the 6.1 release of the client utilities.

Steve Hummel
Sr. Product Manager
Teradata, a division of NCR

  <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