Archives of the TeradataForum

Message Posted: Thu, 29 Jul 2010 @ 08:30:32 GMT

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

Hi,

From our experience (admit it was on V2R62 but must be same on TD12): we noticed that when we enabled Object Throttle at user-level and workload throttles, in a way queries actually get delayed only once not twice. When users submit many queries at the same time they all reach top of the workload delay queue at the same time but kept aside in 'Throttled Objects queue' and only released into active queue (or workload delay queue) as per limit set in object-throttle.

So if you are implementing object throttles, make sure that Workload throttle width is bigger than object-throttle. So that one user will not consume the workload limits.

Regards,

Sivaji G.V
DWSDBA

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