Post reply

resource governor implementation

  • August 18, 2011 at 1:27 pm

    #255952

    Hello All

    have anyone implemented Resource governor in their prod environment?

    pros and cons?

    we have implemented in test environment,. i have few question related to it.

    when will resource governor kick in , is it when cpu contention occurs or when it hits the ceiling.

    how abt memory consumption, when will the condition apply?

    thanks for the help

  • August 18, 2011 at 1:41 pm

    #1370354

    The resource governor handles the MIN and MAX setting for CPU and memory differently. In the case of CPU, the MIN and MAX kicks in only when there is contention. But in the case of memory, as soon as you set the MIN amount, that much is reserved for that pool. It does not matter if the pool is idle or not.

    -Roy

  • August 18, 2011 at 2:00 pm

    #1370379

    what happens if the memory requested by operations managed by resource governor exceeds the pool.. will it page out?

    can you please explain with this scenario in mind

    if the max server memory is 100gb and i create a resource pool with 0% min memory and 100% max memory, what will happen?

    cpu contention--if i see processes waiting for the cpu, can i consider it as contention or should i consider contention only when cpu hits 100%?

    thanks

  • August 18, 2011 at 2:08 pm

    #1370386

    let us say that there are two pools. Pool a and pool b. Pool a is sitting idle, therefore the CPU is available to Pool B even if it has already attained its Max set. That means that Pool B can use 100% of CPU. let us say that the Pool A comes very active now, then Pool B will release the CPU usage for Pool A. Does that answer the CPU question?

    In the case of memory, let us say that the Min value set for pool A comes to 2 GB. That is already reserved. The 2 GB will not be released to pool B even though Pool A is not doing anything and Pool B is starved of memory. At that point paging out can occur.

    Keep in mind that if the Internal pool thinks that it needs all the CPU and Memory, the other pools Min has no effect.

    -Roy

  • August 18, 2011 at 2:10 pm

    #1370388

    thanks a lot!!

  • August 18, 2011 at 2:16 pm

    #1370391

    In the case of memory, let us say that the Min value set for pool A comes to 2 GB. That is already reserved. The 2 GB will not be released to pool B even though Pool A is not doing anything and Pool B is starved of memory. At that point paging out can occur.

    Keep in mind that if the Internal pool thinks that it needs all the CPU and Memory, the other pools Min has no effect.

    sorry one more question

    what about the max memory..if the max memory comes to 100gb for pool A..will that be reserved too?

  • August 18, 2011 at 2:21 pm

    #1370397

    No, Max memory is not reserved. Min is reserved. If the pool needs more than the minimum that is already there, then it will take more memory that is available to it till the maximum value.

    -Roy

  • August 18, 2011 at 2:22 pm

    #1370399

    thanks!! thanks!!

    i couldn't find enough documentation for resource governor online..

    thanks for ur help..

  • August 18, 2011 at 2:31 pm

    #1370404

    I actually write an article fro SQLpass.org site. You need to be a member of sqlpass to read it. If you are, take a look at it. You might find some more interesting titbits.

    -Roy

  • August 18, 2011 at 2:56 pm

    #1370426

    thanks again..

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply