How do you stop demoted queries from hogging CPU?

General
Fan

How do you stop demoted queries from hogging CPU?

We have implemented a 'Penalty Box' workload within TASM for queries that are demoted after reaching specific exception criteria with the idea that they go into a workload which has a low CPU allocation.

We have seen a high % of CPU be taken into the Penalty box and remain with the query for a significant period.

We have been told that this maybe due to the box going into flow control. Is there any way to stop the CPU being hogged even when in flow control?

2 REPLIES
Enthusiast

Re: How do you stop demoted queries from hogging CPU?

How have you defined your penalty box cpu allocation?

If there is no hard limit it can consume any available cpu on the system

You also need to be aware that if you have many queries going into the penalty box you could end up tying up AWT's because processing will take longer.

When using a penalty box, you really need to make sure you are clear on what kind of situation you are trying to resolve.

--Shelley

Teradata Employee

Re: How do you stop demoted queries from hogging CPU?

You could use Workload Throttles to control the excessive consumption of AWT, thus preventing the Flow Control.