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 2 of 3

««1 2 3 »»

How to Post Performance Problems

Rate Topic

Display Mode

Topic Options

Author

Message

epriddy

Posted Friday, June 12, 2009 9:45 AM

SSC Journeyman

Group: General Forum Members
Last Login: Monday, October 22, 2012 4:46 PM
Points: 77, Visits: 110

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

Post #733971

JJ B

Posted Friday, June 12, 2009 9:49 AM

SSC Veteran

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 5:03 PM
Points: 255, Visits: 2,405

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.

Post #733976

Jeff Moden

Posted Friday, June 12, 2009 12:40 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 5:33 PM
Points: 32,902, Visits: 26,783

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

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

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #734078

David Burrows

Posted Tuesday, June 16, 2009 6:48 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 10:44 AM
Points: 6,351, Visits: 5,360

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 Smile

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

Anon.

Post #735604

MattieNH

Posted Thursday, June 18, 2009 9:32 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 10:12 AM
Points: 2,377, Visits: 707

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

Post Attachments

GreyedOut.bmp (4 views, 2.29 MB)

Post #737679

GilaMonster

Posted Thursday, June 18, 2009 9:41 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 5:49 PM
Points: 37,671, Visits: 29,925

Are you sure that the server's SQL 2005 or 2008? The save-as will be greyed out if the server is SQL 2000. If that's the case, follow the steps for SQL 2000.

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 #737688

MattieNH

Posted Thursday, June 18, 2009 10:04 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 10:12 AM
Points: 2,377, Visits: 707

Gail,

That's why you're the exceptional DBA, or at least one of the judges. That's exactly it, almost all of our databases are still 2000, and this is one of them. I'm just so entrenched in using QA/EM for 2000, and SSMS for 2008, and I forget that it's the database, not the IDE.

Thanks so much,
Mattie

Post #737721

ALZDBA

Posted Saturday, June 20, 2009 5:09 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 5:15 AM
Points: 6,861, Visits: 8,046

Great article Gail.
I'll add it to my forum signature w00t

Johan

     Jul 13

Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere w00t

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

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

"press F1 for solution", "press shift+F1 for urgent solution" BigGrin

Need a bit of Powershell? How about this

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

Post #738797

SQLRNNR

Posted Tuesday, August 25, 2009 12:41 PM

SSCoach

Group: General Forum Members
Last Login: Today @ 1:07 PM
Points: 18,733, Visits: 12,332

Nice article Gail.

Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #776989

Dugi

Posted Thursday, September 17, 2009 3:28 AM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, April 02, 2013 1:48 AM
Points: 1,252, Visits: 3,367

The Article is very nice and perfect organized. Thanks for sharing!

Smile

============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/

Post #789485

« Prev Topic | Next Topic »

27 posts, Page 2 of 3

««1 2 3 »»

Permissions