How the Resource Governor Helped Our Report Server.

  • Comments posted to this topic are about the item How the Resource Governor Helped Our Report Server.

    -Roy

  • Very nice HowTo article, Roy :smooooth:

    It's this kind of short ToDo's that will get people started with testing the ResGov and exploring its purposes and usages.

    Thank your for sharing.

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • Very Nice Article..Roy..

    Thanks For sharing...

  • Nice Article Roy.

    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

  • I totally agree with ALZDBA, your article makes me want to go play with the functionality; it's easy to understand for someone who doesn't know what the RG is, gives the problem, the steps needed, and the solution.

    Nice job!

    Jon

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • Great article, thanks!

    Now if we just had the Enterprise version on all the servers...

  • +1. I have so many applications for resource governor, one such use came to mind this morning, where we have a third party application which lets users run adhoc reports against various highways data without suitable validation. The result, a rogue user caused 100% CPU utilisation for a sustained period of time. If my employer had bought Entrerprise Edition we wouldn't have had to rely on education and trust and the user would still have use of their legs 😉

  • Fantastic article. Made me want to go look at it (just for the learning experience since we are a small place and don't suffer from load issues-- yet).

    Unfortunaltely due to that we have the workgroup edition...

    Oh how I cried at the things I was missing, most of all the profiler 🙁

    For only a few pennies more.

    [font="Arial"]_______________________________________________________
    Change is inevitable... Except from a vending machine.[/font]

  • First let me apologize for not responding yesterday. I was sick and was laid low in bed.

    Thank you all for the compliments. I hope this will help in giving you all new ideas on how this functionality can be used.

    -Roy

  • Nice article for RG Starters

  • Thx Aravinda...

    -Roy

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

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