Post reply

viewing the compiled plans in cache

  • July 22, 2010 at 7:20 am

    #223526

    HI All

    Is the there a way to see the execution plan(the diagramatic form where I can see seeks,scans etc.) for the compiled plans stored in the proc cache?

    I can see the compiled plan using sys.syscachedobjects or sys.dm_exec_cached_plans but not the execution plan.

    Any ideas?

    Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.

  • July 22, 2010 at 7:25 am

    #1196839

    Query sys.dm_exec_cached_plan CROSS APPLY sys.dm_exec_query_plan. The exec plan is in the second, in xml format.

    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

  • July 22, 2010 at 7:33 am

    #1196844

    You are good and you are fast....thanks 🙂

    Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.

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

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