Benefits of Resource Governor

  • Comments posted to this topic are about the item Benefits of Resource Governor

  • Good question thanks

    ...

  • This was removed by the editor as SPAM

  • Stewart "Arturius" Campbell (6/13/2016)


    Nice one, thanks Junior

    Had to read up on this, so learned something today...

    +1

    😉

  • I've yet to actually use the Resource Governor. But the question made me read up on it.

  • Interesting question.

    Even more interesting answer statistics. The documentation is very clear and up-front about two limitations: (i) resource govenor doesn't work across instances and(ii) resource govenor doesn't concern itself with system tasks, only user tasks. So which two of the six options are not supported is surely absolutely obvious to anyone who has read the documentation or who reads it to find teh answer to this question, so selecting which four are supported ia rather easy. Yet of the answers to date, more than two thirds have selected at least one of the two unsupported options, and more than one in five has selected both unsupported options.

    Clearly people need to be better educated in this area, if they are to be capable of using Resource Governor. So this is a very good question from the point of view of showing people where they need to do some learning.

    Tom

  • Hi Tom,

    Thanks for your comments.

  • 🙂

  • 🙂

  • Thanks Junior for an interesting question with carefully worded answer options 🙂

  • TomThomson (6/14/2016)


    Interesting question.

    Even more interesting answer statistics. The documentation is very clear and up-front about two limitations: (i) resource govenor doesn't work across instances and(ii) resource govenor doesn't concern itself with system tasks, only user tasks. So which two of the six options are not supported is surely absolutely obvious to anyone who has read the documentation or who reads it to find teh answer to this question, so selecting which four are supported ia rather easy. Yet of the answers to date, more than two thirds have selected at least one of the two unsupported options, and more than one in five has selected both unsupported options.

    Clearly people need to be better educated in this area, if they are to be capable of using Resource Governor. So this is a very good question from the point of view of showing people where they need to do some learning.

    I agree. And given that the answers were an exact copy from the BOL page it is rather pathetic. I think resource governor is highly under-utilized because so many people don't understand it well enough to use it.

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

  • Sean Lange (6/14/2016)


    TomThomson (6/14/2016)


    Interesting question.

    Even more interesting answer statistics. The documentation is very clear and up-front about two limitations: (i) resource govenor doesn't work across instances and(ii) resource govenor doesn't concern itself with system tasks, only user tasks. So which two of the six options are not supported is surely absolutely obvious to anyone who has read the documentation or who reads it to find teh answer to this question, so selecting which four are supported ia rather easy. Yet of the answers to date, more than two thirds have selected at least one of the two unsupported options, and more than one in five has selected both unsupported options.

    Clearly people need to be better educated in this area, if they are to be capable of using Resource Governor. So this is a very good question from the point of view of showing people where they need to do some learning.

    I agree. And given that the answers were an exact copy from the BOL page it is rather pathetic. I think resource governor is highly under-utilized because so many people don't understand it well enough to use it.

    Are you assuming people read the docs before answering? Or just assumed something? If it's the latter, I think the statistics make sense. People haven't used this and guessed.

    If it's the former, that's disturbing.

  • Steve Jones - SSC Editor (6/14/2016)


    Sean Lange (6/14/2016)


    TomThomson (6/14/2016)


    Interesting question.

    Even more interesting answer statistics. The documentation is very clear and up-front about two limitations: (i) resource govenor doesn't work across instances and(ii) resource govenor doesn't concern itself with system tasks, only user tasks. So which two of the six options are not supported is surely absolutely obvious to anyone who has read the documentation or who reads it to find teh answer to this question, so selecting which four are supported ia rather easy. Yet of the answers to date, more than two thirds have selected at least one of the two unsupported options, and more than one in five has selected both unsupported options.

    Clearly people need to be better educated in this area, if they are to be capable of using Resource Governor. So this is a very good question from the point of view of showing people where they need to do some learning.

    I agree. And given that the answers were an exact copy from the BOL page it is rather pathetic. I think resource governor is highly under-utilized because so many people don't understand it well enough to use it.

    Are you assuming people read the docs before answering? Or just assumed something? If it's the latter, I think the statistics make sense. People haven't used this and guessed.

    If it's the former, that's disturbing.

    Well I suppose many people probably just answered it without any research and guessed.

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

  • Got it directly from here.

    https://msdn.microsoft.com/en-us/library/bb933866.aspx

    By the way, I used to have under impression that IO is not controlled via RG.

    Thanks.

  • Thank you for the post, good one.

    (I felt this was a trick question as started reading the choices and had to compare with the BOL to see any word that negates; with more options it would have been bit tough to select the right choices.)

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

Viewing 15 posts - 1 through 15 (of 19 total)

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