All geek questions in one place

SQL Resource Governor reallocates resources at query time?

Let's say I have two users (U1, U2) mapped to two resource pools (R1, R2) and the maximum values ​​are 20% and 80%. U1 performs a time-consuming request that lasts about 15 minutes. When he started execution, it was the only process, and so the SQL server allocated full resources for this query. After 5 minutes, U2 makes another request. Will the Resource Governor reduce U1 resources to 20% and allow U2 to accept 80% or will he wait for U1 to finish and then allow U2 80%.

I agree that the first case is what is expected, but I saw this post and became curious. Please explain what will happen in the real scenario.

+3
source share
1 answer

A reserve resource is launched only when there is competition for resources. If a particular connection does not meet any arguments in its desire to use all the resources in the field, it will be.

So, if there is a process that runs for an hour or so, but within ten minutes there is a process that wants 80% (and it is allowed to use 80%), then the original process will be reduced to 20% in these ten minutes.

Hope this clears it for you.

+2
source

Source: https://habr.com/ru/post/1726341/

More articles:


All Articles