Post reply

Know how old an execution plan is

  • September 28, 2010 at 2:22 pm

    #229855

    Hi everyone,

    I am trying to get the date an execution plan for an SP is generated, I thought that I would be able to get it through this DMV sys.dm_exec_cached_plans but the piece of information isn't here.

    Thanks in advance for any help.

    Frank.

  • September 28, 2010 at 2:45 pm

    #1228667

    It's in sys.dm_exec_query_stats

    Be careful, there's a 1-many relationship between sys.dm_exec_cached_plans and sys.dm_exec_query_stats. Group by the plan handle.

    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

  • September 28, 2010 at 3:01 pm

    #1228673

    Thanks Gail 🙂 that helped me out

    Frank.

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

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