All Forums General
BBPaul 2 posts Joined 05/10
14 May 2013
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?

Shelley 28 posts Joined 09/10
30 May 2013

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.

VBurmist 96 posts Joined 12/09
10 Jun 2013

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

You must sign in to leave a comment.