Post reply

Resource Govenor for CPU usage

  • May 3, 2022 at 9:50 am

    #4025879

    I need to set up a resource governor to restrain CPU use on one of my instances. But though I can find lots of articles telling me that I can do this, I can't find any that show code for the workload group. I've tried a number of things but because I'm writing queries for this attempt, the workload group won't create properly given that the queries aren't schema binding.

    Does anyone have any advice or a link to any articles that can provide what I need?

    EDIT: To clarify, I'm trying to restrict one database's CPU usage. I just found a way to change the default resource pool, but I'd like to avoid that if possible.

     

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • May 4, 2022 at 10:10 am

    #4026509

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • May 18, 2022 at 4:09 pm

    #4035070

    Brandie,

    Would you post some of your scripting so we can get a better sense of how you are going about it?  Also, in case it solves the problem, you can set the MAXDOP database setting (as opposed to the server MAXDOP setting.)

    --Will

  • May 18, 2022 at 8:07 pm

    #4035200

    This might help you:

    https://blog.sqlauthority.com/2012/06/04/sql-server-simple-example-to-configure-resource-governor-introduction-to-resource-governor/

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply