Archives of the TeradataForum

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

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

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