Resource Governor

Last post 10-21-2008 5:46 AM by ghemant. 6 replies.
Page 1 of 1 (7 items)
Active Topics My Discussions Unanswered Sort Posts: Previous Next

  • 03-28-2008 7:09 AM

    • Akthar
    • Top 25 Contributor
    • Joined on 10-01-2004
    • Mauritius
    • Posts 616

    Resource Governor

    Reply Contact

    hi,

    Can we configure RG for a specific query or Stored proc instead of a User or Group?

    AKTHAR
    http://ecmmauritius.blogspot.com
    http://sharepointmauritius.blogspot.com

  • 03-29-2008 12:22 PM In reply to

    Re: Resource Governor

    Reply Contact

     

    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

    Madhu K Nair
    http://madhuottapalam.blogspot.com/
    http://experiencing-sql-server-2008.blogspot.com/

  • 03-31-2008 3:09 AM In reply to

    Re: Resource Governor

    Reply Contact

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

    Hemantgiri S. Goswami | MS SQL Server MVP
    -------------------------
    "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami

    http://hemantgirisgoswami.blogspot.com
    http://forums.surat-user-group.org/

    View Hemantgiri S. Goswami's profile on LinkedIn

    Disclaimer: This post is provided as is, for the sake of knowledge sharing only.

  • 03-31-2008 4:06 AM In reply to

    • satya
    • Top 10 Contributor
    • Joined on 11-05-2002
    • United Kingdom
    • Posts 22,567
    • Microsoft MVP
      Moderator

    Re: Resource Governor

    Reply Contact

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

    -Satya S K J

    SQL Server MVP



    Knowledge is Power, you will gain by sharing it. SSQA.net - Invisible contributions to the users & visible success in SQL Community.

  • 09-05-2008 11:21 AM In reply to

    Re: Resource Governor

    Reply Contact

    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

  • 10-21-2008 2:37 AM In reply to

    • umair
    • Not Ranked
    • Joined on 10-21-2008
    • Posts 1

    Re: Resource Governor

    Reply Contact

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

    Get your website to be ranked on the top through our Search Engine Marketing service.

  • 10-21-2008 5:46 AM In reply to

    Re: Resource Governor

    Reply Contact

    Hi,

    Here is a nice example on RG by Andrew Fryer http://blogs.technet.com/andrew/archive/2007/11/25/sql-server-2008-resource-governor.aspx 

     

    Hemantgiri S. Goswami | MS SQL Server MVP
    -------------------------
    "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami

    http://hemantgirisgoswami.blogspot.com
    http://forums.surat-user-group.org/

    View Hemantgiri S. Goswami's profile on LinkedIn

    Disclaimer: This post is provided as is, for the sake of knowledge sharing only.
Page 1 of 1 (7 items)
Active Topics   My Discussions    Unanswered Posts


© 2000 - 2007 vDerivatives Limited All Rights Reserved.