InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 07:58:19 GMT20http://www.sqlservercentral.com/Forums/Topic590251-32-1.aspxYep - 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.TroyKFri, 24 Oct 2008 12:04:35 GMTcs_troykhttp://www.sqlservercentral.com/Forums/Topic590251-32-1.aspxNo, I have yet to try that.Thu, 23 Oct 2008 10:20:49 GMTRBarryYounghttp://www.sqlservercentral.com/Forums/Topic590251-32-1.aspxYes, the ShowPlan_XML does display graphically in Profiler.Barry,Have you used the ability to import and sync with Performance monitor logs yet?Thu, 23 Oct 2008 09:57:40 GMT Jack Corbetthttp://www.sqlservercentral.com/Forums/Topic590251-32-1.aspxIt 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...Thu, 23 Oct 2008 09:53:41 GMTRBarryYounghttp://www.sqlservercentral.com/Forums/Topic590251-32-1.aspxWhile 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 -[i]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.[/i]Thu, 23 Oct 2008 09:19:52 GMTthbaconhttp://www.sqlservercentral.com/Forums/Topic590251-32-1.aspxComments posted to this topic are about the item [B]<A HREF="/questions/Profiler/64615/">Profiler</A>[/B]Wed, 22 Oct 2008 23:34:47 GMTSteve Jones - SSC Editor