How to Post Performance Problems

  • Comments posted to this topic are about the item How to Post Performance Problems

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Well done, Gail!

    I think this is going to be part of many people's signature like Jeff's article on posting best practices.

    -- Gianluca Sartori

  • Thanks Gila, nice article! Looks like it will be a great help to the n00bs. I didn't think of attaching a query plan to my questions, but I'll do so in future where relevant.

  • YAY!

    Now if only people will read and follow the advice here.

    Well done. Very nicely laid out and explained.

    ----------------------------------------------------
    The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
    Theodore Roosevelt

    The Scary DBA
    Author of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

  • Excellent article, Gail.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]

  • Will be adding to my sig, for sure. 😀

    Thanks, great 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."

  • Grant Fritchey (6/12/2009)


    Now if only people will read and follow the advice here.

    Read it is a possibility. Expecting everyone to follow the advice might be a little too much to ask for though.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Fully agree with the post and recommendation from Gail.

    A general comment to posts where somebody is asking for help: It would also be nice if the solution to the problem is posted as well even the person itself finds the solution.

    Often I come across threats in forums where at the end and after several pages of replies from others the originator writes: If could fix it myself. No further explanation what he did and why it worked again. :crying:

    Have a nice weekend all together.

    liebesiech:-D

  • This is a great post for initializing peformance problem.

  • I already added it to my signature block!

  • LOVE the tips!! At work, I'm a go-to person for query help and agree that the 3000+ is a bit overwhelming. I'm going to encourage users to read your article!! 😉

  • I really liked you article not only because it was very easy for anyone to read and understand, but because the tone was polite and not condescending as sometimes happens in these types of articles. Great job.

  • GilaMonster (6/12/2009)


    Grant Fritchey (6/12/2009)


    Now if only people will read and follow the advice here.

    Read it is a possibility. Expecting everyone to follow the advice might be a little too much to ask for though.

    Outstanding article, Gail. Added that bad boy to my signature line. 😉

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • Lynn Pettis (6/12/2009)


    I already added it to my signature block!

    Many more and it will be a full blown reference library :w00t:

    btw Excellent article Gail 🙂

    Far away is close at hand in the images of elsewhere.
    Anon.

  • Hi Gail,

    Your article discusses exactly the kind of question I'd be likely to post, and I'd love to follow your suggestions. And being brand new to a post-2000 SQL Server, I figured I'd follow along and create an execution plan on a stored procedure. I was with you all the way up to Include Actual Execution Plan, but when I right click on the execution plan tab and bring up the menu to Save Execution Plan As, that option, as well as the Show Execution Plan XML option, are greyed out. Am I missing a step somewhere? I've attached a screen picture of what I'm seeing.

    I agree, it was an excellent 'how to' article.

    Thanks,

    Mattie

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

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