June 12, 2009 at 12:40 am
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
June 12, 2009 at 2:29 am
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
June 12, 2009 at 4:41 am
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.
June 12, 2009 at 6:16 am
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
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 12, 2009 at 6:51 am
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]
June 12, 2009 at 7:04 am
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."
June 12, 2009 at 7:09 am
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
June 12, 2009 at 7:46 am
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
June 12, 2009 at 8:19 am
This is a great post for initializing peformance problem.
June 12, 2009 at 8:55 am
I already added it to my signature block!
June 12, 2009 at 9:45 am
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!! 😉
June 12, 2009 at 9:49 am
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.
June 12, 2009 at 12:40 pm
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
Change is inevitable... Change for the better is not.
June 16, 2009 at 6:48 am
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.
June 18, 2009 at 9:32 am
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 33 total)
You must be logged in to reply to this topic. Login to reply