ResourceGovernor

• ramana3327

  SSCoach

  Points: 19722

  More actions

  December 16, 2013 at 10:49 am

  #281387

  I enable the Resource Governor in SQLServer2008R2 developer instance.

  I created new Resource Pool with name 'Ram' with Min CPU, Max CPU, Min Memory & Max Memory all with 5% and created work load group 'Ram' with medium importance, max requests2, CPU time 10 sec, memory grants 5%.

  I have a user name 'sirisha'. If I want to add this user to that resource pool & Work load group how can I do?

• JeremyE

  SSCoach

  Points: 16199

  More actions

  December 16, 2013 at 2:13 pm

  #1673869

  You need to create a classifier function.

  http://technet.microsoft.com/en-us/library/hh510208.aspx

• ramana3327

  SSCoach

  Points: 19722

  More actions

  December 18, 2013 at 3:31 pm

  #1674648

  Thank you