Post reply

Finding date/time for execution plans

  • April 23, 2010 at 8:34 am

    #220797

    Hey all,

    Is there any DMV I'm missing that has any type of date/time field for last time used like that of lasttime from syscacheobjects? I'm pulling data from dm_exec_cached_plans, dm_exec_sql_text, dm_exec_query_plan, dm_exec_plan_attributes, dm_os_memory_objects & dm_os_memory_cache_entries ... none of which have some of the fields from syschacheobjects. I'm hoping that I'm simply missing a dmv/dmf here.

    Thanks

  • April 23, 2010 at 8:56 am

    #1156922

    Interesting, the lasttime is always 0 even in 2000, crap.

    So is this data available anywhere?

  • April 25, 2010 at 7:52 am

    #1157387

    try sys.dm_exec_query_stats

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

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