Profiler

Question

Profiler

Steve Jones - SSC Editor

SSC Guru

Points: 736150
More actions
October 22, 2008 at 11:34 pm

#63586

Comments posted to this topic are about the item Profiler

Viewing 6 posts - 1 through 5 (of 5 total)

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

thbacon SSChasing Mays Points: 659 More actions · Answer 1

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.

RBarryYoung SSC Guru Points: 143329 More actions · Answer 2

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

[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]

Jack Corbett SSC Guru Points: 184394 More actions · Answer 3

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
Consultant - Straight Path Solutions
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

RBarryYoung SSC Guru Points: 143329 More actions · Answer 4

No, I have yet to try that.

[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]

cs_troyk SSCertifiable Points: 5383 More actions · Answer 5

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