How to Post Performance Problems

Question

Post reply

How to Post Performance Problems

Gail Shaw

SSC Guru

Points: 1004504
More actions
June 12, 2009 at 12:40 am

#210850

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

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

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

spaghettidba SSC Guru Points: 105732 More actions · Answer 1

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

AndrewJacksonZA SSCarpal Tunnel Points: 4143 More actions · Answer 2

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.

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 3

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

RBarryYoung SSC Guru Points: 143329 More actions · Answer 4

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]

jcrawf02 SSC-Insane Points: 24198 More actions · Answer 5

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."

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 6

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

liebesiech SSCrazy Points: 2610 More actions · Answer 7

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

jsterrett SSC-Addicted Points: 459 More actions · Answer 8

This is a great post for initializing peformance problem.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 9

Lynn Pettis

SSC Guru

Points: 442467

June 12, 2009 at 8:55 am

#1008725

I already added it to my signature block!

epriddy Old Hand Points: 343 More actions · Answer 10

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!! 😉

JJ B SSCertifiable Points: 5130 More actions · Answer 11

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.

Jeff Moden SSC Guru Points: 1004321 More actions · Answer 12

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)

David Burrows SSC Guru Points: 65142 More actions · Answer 13

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.

MattieNH SSCertifiable Points: 7463 More actions · Answer 14

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