Post reply

Resource Governor

  • April 4, 2013 at 11:32 pm

    #74471

    Comments posted to this topic are about the item Resource Governor

  • April 4, 2013 at 11:39 pm

    #1603806

    I just guess and got correct 2 out of 3.

    :doze:

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

  • April 5, 2013 at 12:36 am

    #1603816

    Nice question, thanks!

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • April 5, 2013 at 4:26 am

    #1603846

    Not using 2012 yet so 2 out of 3 ain't bad. Good to know though for when we do upgrade.

    MCITP
    MCTS - E-Business Card
    Twitter: WWDMark

    Try not! Do or do not, there is no try

    email: info@weekendwebdesign.co.uk
    Personal Website: http://markallen.co.uk/
    Business Website: https://www.weekendwebdesign.co.uk

  • April 5, 2013 at 5:55 am

    #1603859

    Knew two - guessed the 3rd .... but wondering how many of those answering the question actually use the Resource Governor ?

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • April 5, 2013 at 7:22 am

    #1603891

    bitbucket-25253 (4/5/2013)

    Knew two - guessed the 3rd .... but wondering how many of those answering the question actually use the Resource Governor ?

    + 1


    Everything is awesome!

  • April 5, 2013 at 10:54 am

    #1604029

    bitbucket-25253 (4/5/2013)

    Knew two - guessed the 3rd .... but wondering how many of those answering the question actually use the Resource Governor ?

    I do I do! Not on 2012 (yet), but we have some people who have rights to run queries against our production server. They go into a resource governor pool that keeps them from swallowing all of the resources on the server with their

    "I know SQL" queries.


    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

  • April 5, 2013 at 12:18 pm

    #1604067

    Even though the question said "the three options", I went and picked only two. I've never used the resource governor, so I wouldn't have gotten it right anyway. =P

    This made me wonder: what does the minimum CPU setting mean? If there aren't enough queries on that resource pool to reach the minimum, the server will dedicate its resources to that anyway?

  • April 5, 2013 at 9:35 pm

    #1604191

    Thanks for the question.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • April 25, 2013 at 1:43 am

    #1609801

    Good easy question. 🙂

  • June 9, 2015 at 12:27 am

    #1803873

    An easy one !

Viewing 11 posts - 1 through 10 (of 10 total)

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