How to Post Performance Problems

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Gail Shaw » How to Post Performance Problems

27 posts, Page 1 of 3

1 2 3 »»»

How to Post Performance Problems

Rate Topic

Display Mode

Topic Options

Author

Message

GilaMonster

Posted Friday, June 12, 2009 12:40 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 4:30 AM
Points: 37,742, Visits: 30,021

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

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #733541

spaghettidba

Posted Friday, June 12, 2009 2:29 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 8:17 AM
Points: 4,804, Visits: 8,074

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

Get your two-cent-answer quickly
The Spaghetti DBA

Post #733588

AndrewJacksonZA

Posted Friday, June 12, 2009 4:41 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 5:52 AM
Points: 165, Visits: 1,022

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.

Post #733674

Grant Fritchey

Posted Friday, June 12, 2009 6:16 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 3:41 AM
Points: 13,383, Visits: 25,189

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 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software

Post #733732

RBarryYoung

Posted Friday, June 12, 2009 6:51 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Saturday, May 04, 2013 11:13 AM
Points: 9,855, Visits: 9,374

Excellent article, Gail.

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc. "Performance is our middle name."

Post #733758

jcrawf02

Posted Friday, June 12, 2009 7:04 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 6:29 AM
Points: 2,551, Visits: 18,885

Will be adding to my sig, for sure. BigGrin

Thanks, great job!

Jon

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

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

Post #733773

GilaMonster

Posted Friday, June 12, 2009 7:09 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 4:30 AM
Points: 37,742, Visits: 30,021

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 2008, MVP
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

Post #733781

liebesiech

Posted Friday, June 12, 2009 7:46 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 10, 2013 3:55 AM
Points: 126, Visits: 751

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