sys.dm_exec_query_stats

Description

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 the plan itself. When a plan is removed from the cache, the corresponding rows are can vary with each execution as the data only reflects finished queries, and not ones still in-flight.

Syntax

sys.dm_exec_query_stats