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 […]