Ensuring Resource Governor group doesnt cross numa boundary

• winston Smith

  SSCoach

  Points: 19500

  More actions

  December 19, 2013 at 3:58 am

  #287619

  I have a heavy nightly batch process that is encountering thread starvation on my 2008 SP3 server.

  Rather than limit MAXDOP at the instance level, I would like to do it at the Resource Governor level, and target the nightly batch only.

  Based on MS literature, experience and advice from collegues, I should limit the resource group to the CPU's on one Numa node, i.e. prevent crossing boundaries .

  Resource governor allows me to set a maxdop, but I cant ensure that the processors it picks when doing a parallel query will be on the same node.

  is there any way to control this?

• David Benoit

  SSC-Dedicated

  Points: 34562

  More actions

  December 19, 2013 at 6:51 am

  #1674796

  Unfortunately, no, there isn't a way to control this.

  David

  @SQLTentmaker

  “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot