Post reply

Graphical Query Plan

  • December 12, 2011 at 9:31 am

    #253286

    Hi I am using SQL2008R2SP1. Is there a way I can view a graphical query plan from showplan xml?

    I notice when I return a query plan from sys.dm_exec_query_plan for example:

    SELECT [qp].[query_plan]

    FROM sys.dm_exec_cached_plans cp

    CROSS APPLY sys.dm_exec_sql_text (cp.plan_handle) st

    CROSS APPLY sys.dm_exec_query_plan (cp.plan_handle) qp

    where [st].[objectid] = 12345678

    If I click on the output and this shows the showplan xml. How do I view the graphical plan from this?

    Thanks in advance.

  • December 12, 2011 at 9:35 am

    #1420154

    http://sqlblog.com/blogs/aaron_bertrand/archive/2011/10/28/getting-graphical-showplan-back-in-sql-server-2008-r2.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    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

  • December 12, 2011 at 11:00 am

    #1420195

    Gail, thankyou very much. Thats much easier to read!

Viewing 3 posts - 1 through 2 (of 2 total)

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