Archives of the TeradataForum
Message Posted: Thu, 18 Oct 2001 @ 21:35:18 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|