MSSDSRV.EXE or MSSQLServerOLAPService won't take more 50% of CPU

• SQLHeap

  Hall of Fame

  Points: 3572

  More actions

  February 25, 2013 at 11:03 am

  #290271

  The resource governor is not on, can't seem to figure out why it won't go beyond 50%. It's a hard stop right there. Am I missing a configuration somewhere? Have SQL2008r2 on Server2008r2, 2 CPU, 12gb Ram.

  There is an exception to every rule, except this one...