Post reply

Resource Governor 2014

  • May 6, 2015 at 11:52 pm

    #75716

    Comments posted to this topic are about the item Resource Governor 2014

  • May 7, 2015 at 12:51 am

    #1796114

    good explanation, thanks steve for QOD.

  • May 7, 2015 at 3:31 am

    #1796140

    Great question, thanks.

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

  • May 7, 2015 at 4:44 am

    This was removed by the editor as SPAM

  • May 7, 2015 at 5:25 am

    #1796161

    Thanks, Steve. Nice question to get the brain cells going.

    Tally Tables - Performance Personified
    String Splitting with True Performance
    Best practices on how to ask questions

  • May 7, 2015 at 7:00 am

    #1796197

    Stewart "Arturius" Campbell (5/7/2015)

    Good to know what can and can't be done with Resource Govenor.

    Thanks for the question, Steve

    +1 Great question Steve.


    Everything is awesome!

  • May 7, 2015 at 7:21 am

    #1796209

    Thanks, Steve! Another great question.

    - webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

  • May 7, 2015 at 8:09 am

    #1796232

    The research to answer the question correctly was very interesting! Thanks for the question.

  • May 7, 2015 at 10:58 am

    #1796313

    Thank you for the post, Steve, really good one. I really took lot of time (really lot) just to understand the question... then I realized RG can control CPU, Memory... that kind of stuff... but log writes...? I got green. 🙂

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

  • May 8, 2015 at 3:58 pm

    #1796753

    Good question, but ...

    The first three options are obviously incorrect (the first two because restricting log writes isn't possible, the third because there's no such thing as MAX_IOPS_PERCENTAGE, the nearest thing is MAX_IOPS_PER_VOLUME) and the fourth one is correct. SO as far as that goes, teh correct answer is teh right answer.

    But the fourth one doesn't suggest anything one might do to fix the problem that is the subject of the question, so althought it is a corect answer it's an absolutely useless one for a DBA confronted by the problem - he'd be better off looking up how to do the third option and discovering what he could do instead. I don't think that would lead anyone to suggest that the tird option is the correct answer, it seems obvious that the fourth one is the one the question is ooking for, but it is rather a pity that no way forward for teh DBA's problem is indicated.

    Tom

  • May 10, 2015 at 12:04 am

    #1796831

    Stewart "Arturius" Campbell (5/7/2015)

    Good to know what can and can't be done with Resource Govenor.

    Thanks for the question, Steve

    + 1

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • May 11, 2015 at 11:13 am

    #1797044

    Dana Medley (5/7/2015)

    Stewart "Arturius" Campbell (5/7/2015)

    Good to know what can and can't be done with Resource Govenor.

    Thanks for the question, Steve

    +1 Great question Steve.

    I agree. BTW, still love your avatar.

  • May 12, 2015 at 9:56 am

    #1797318

    V Nice Question. The best part to solve Steve Jone's questions are , we need to read this thoroughly and carefully.

    Keep posting more exciting questions, Steve!

    Thanks.

Viewing 13 posts - 1 through 12 (of 12 total)

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