Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 24 Jun 2002 @ 17:23:48 GMT

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

Subj:   Re: TDQM and Limits of CPU
From:   Thomas F. Stanek

Francesca makes a very good point.

IN V2R5.0, PSF will be changed so that AmpWorkerTasks can be associated with a performance group. This will allow you to ensure that this resource is available for the performance group you set up. The initial objective of this feature is to better ensure that AmpWorkerTasks will always be available to process queries with sort response times, i.e. to support active data warehousing.

However, even with this new feature, the fact still remains that queries will utilize AmpWorkerTasks as needed and, all things being equal, reducing a query's priority will cause the associated AmpWorkerTasks to be dedicated to the query in question for a longer period of time.

Unfortunately, the currently available documentation provides little insight into AmpWorkerTasks, how they are utilized, how to monitor, etc. My understanding from talking with NCR is that there will be much more documentation on this subject with the release of V2R5.0.

FYI, there is some monitoring capability with the use of ResUsage data, if you are collecting data in the ResUsageSvpr table.

Thomas F. Stanek
TFS Consulting

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020