SQL Server Performance

Resource Governor

Discussion in 'SQL Server 2008 Questions [Archive Only - Closed]' started by Akthar, Mar 28, 2008.

  1. Akthar New Member

    hi,
    Can we configure RG for a specific query or Stored proc instead of a User or Group?
  2. madhuottapalam New Member

    I have tried RG for Users, but as you said Query/sp/application i have not. But what i feel is, if its not provided then we can achieve that with EXECUTE AS feature. I may be wrong..
    Madhu
  3. WingSzeto Member

    Do you mean you can use RG to limit how much a user can utilize a resource? How do you assign users in RG? I couldn't find it.
    wingman
  4. ghemant Moderator

  5. ghemant Moderator

    AFAIK we can not configure RG for specific query/sp.
  6. satya Moderator

    Other way round is associate a role or group to execute that stored procedure and control the resource via that phase.
  7. umair New Member

    I tried it but can't get success. May be there is some problem!

Share This Page