Profiler

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 Steve Jones » Profiler

Profiler

Rate Topic

Display Mode

Topic Options

Author

Message

Steve Jones - SSC Editor

Posted Wednesday, October 22, 2008 11:34 PM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 6:14 PM
Points: 31,421, Visits: 13,734

Comments posted to this topic are about the item Profiler

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #590251

thbacon

Posted Thursday, October 23, 2008 9:19 AM

SSChasing Mays

Group: General Forum Members
Last Login: Yesterday @ 11:58 AM
Points: 620, Visits: 75

While Profiler lets you capture the show plan in XML, I don't believe Profiler displays it ... the URL in the answer gives a description of the Profiler benefits, but I think the correct answer is "No, you have to use SSMS to display the graph."

From http://msdn.microsoft.com/en-us/library/ms191197(SQL.90).aspx -

To view the Showplan XML Statistics Profile event file in SQL Server Management Studio, on the File menu, point to Open, and click File. Navigate to the directory where you saved the Showplan XML Statistics Profile event file or files to select one and open it. Showplan XML Statistics Profile event files have a .SQLPlan file extension.

Post #590540

RBarryYoung

Posted Thursday, October 23, 2008 9:53 AM

SSCrazy Eights

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

It works for me. I was doing a Performance Analysis delivery just two weeks ago and I added this event and was surprised to see it in the display pane where the SQL commands usually show up. Very nice...

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

Post #590567

Jack Corbett

Posted Thursday, October 23, 2008 9:57 AM

SSChampion

Group: General Forum Members
Last Login: Friday, May 17, 2013 12:22 PM
Points: 10,571, Visits: 11,871

Yes, the ShowPlan_XML does display graphically in Profiler.

Barry,

Have you used the ability to import and sync with Performance monitor logs yet?

Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2

Post #590573

RBarryYoung

Posted Thursday, October 23, 2008 10:20 AM

SSCrazy Eights

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

No, I have yet to try that.

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

Post #590599

cs_troyk

Posted Friday, October 24, 2008 12:04 PM

Ten Centuries

Group: General Forum Members
Last Login: 2 days ago @ 5:22 PM
Points: 1,205, Visits: 684

Yep - I just used this as well to track down a stored proc optimization issue (which, BTW, appeared to be caused by a bug in SS2K5). Very nice feature.

TroyK

Post #591428

« Prev Topic | Next Topic »

Permissions