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?
    Akthar, Mar 28, 2008
    #2

  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
    madhuottapalam, Mar 29, 2008
    #3

  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
    WingSzeto, Sep 5, 2008
    #4

  4. ghemant Moderator

    ghemant, Oct 21, 2008
    #5

  5. ghemant Moderator

    AFAIK we can not configure RG for specific query/sp.
    ghemant, Mar 31, 2008
    #6

  6. satya Moderator

    Other way round is associate a role or group to execute that stored procedure and control the resource via that phase.
    satya, Mar 31, 2008
    #7

  7. umair New Member

    I tried it but can't get success. May be there is some problem!
    umair, Oct 21, 2008
    #8

Share This Page