When was last time Stored Procedure Executed?

All SQL Statement sent to SQL Server Engine is Parsed,Compiled and Executed.The Compiled statements are stored in system tables and can be retried using DMV’s sys.dm_exec_query_stats:Returns aggregate performance statistics for cached query plans in SQL Server. The view contains one row per query statement within the cached plan, and the lifetime of the rows are tied to […]