Resource Pool Limit

Help
1

Hi All,

Is it a good idea set the CPU hard Limit.?
If we are planning to set what is expected impact?

2

Hi @tchaitanya. It’s a good idea if you really want to reserve CPU in other pools for quick use, at the expense of not being able to use all the CPU in the “hard limit” pool if other pools are mostly idle. Read about both

SOFT_CPU_LIMIT_PERCENTAGE
and
HARD_CPU_LIMIT_PERCENTAGE

here.

3

Hi @hanson,

Thank you for the reply.
How much performance impact can we expect if set the HARD_CPU_LIMIT_PERCENTAGE…?

4

It depends on what you set it to. If you set a low hard limit like 5% then you might be giving up 20X in query performance in an otherwise idle situation. These limits are insurance. You have to decide if the opportunity cost is worth the improved predictability.

1 Like