Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 22 May 2015 @ 10:23:22 GMT

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

Subj:   Re: Teradata IWM CPU allocation
From:   Sridhar K

Thanks Ruth for your valuable feedback.

It is just my concern that DEV using all the resources. We don't maintain good stats on DEV/Quality Environment and moreover testers run un- tuned queries & Scripts.

As a result, these queries sometimes run for very long duration using more than 90% of resources, showing system in RED. The same scripts or queries with proper stats and tuning takes less resources and very less amount of time.

So I just wanted to avoid these cases to limit them to use certain max CPU(not to cross 90%) to avoid system showing in RED. ?

It would be nice if you can clarify one more thing. If a low priority workload query is running using all the resources and if some high priority work comes up, will it be pushed down immediately or if it will apply only to the next query of the workload.

Thanks & Regards,

Sridhar K

  <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: 24 Jul 2020