Resource Governor to Restrict a Windows Login/Group.

• gshyam23 92006

  Mr or Mrs. 500

  Points: 550

  More actions

  May 29, 2013 at 12:19 pm

  #278252

  Hello All,

  We have a requirement to restrict a user/group on Production server to use limited resources, i.e. RMA/CPU. Do we have any option in SQL Server Resource Governor to accomplish this task.

  I kindly request to suggest me if we can do this using Resource governor.

  Thanks a lot in advance.

  Regards,

  Shyam.

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  May 29, 2013 at 12:23 pm

  #1619451

  I'd start here: http://msdn.microsoft.com/en-us/library/bb933866(v=sql.100).aspx.