Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Profiler Expand / Collapse
Author
Message
Posted Wednesday, October 22, 2008 11:34 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: 2 days ago @ 11:24 AM
Points: 32,781, Visits: 14,942
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
Posted Thursday, October 23, 2008 9:19 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Tuesday, June 18, 2013 12:00 PM
Points: 633, Visits: 81
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
Posted Thursday, October 23, 2008 9:53 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Friday, March 28, 2014 2:25 PM
Points: 9,902, Visits: 9,479
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
Posted Thursday, October 23, 2008 9:57 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:08 AM
Points: 10,910, Visits: 12,549
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
Posted Thursday, October 23, 2008 10:20 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Friday, March 28, 2014 2:25 PM
Points: 9,902, Visits: 9,479
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
Posted Friday, October 24, 2008 12:04 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, April 17, 2014 6:43 PM
Points: 1,306, Visits: 778
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 »

Add to briefcase

Permissions Expand / Collapse