SQL Server finds the statements that deserve optimization

Method 1,

Sys.dm_exec_qurey_stats returns aggregate performance statistics for cached query plans in SQL Server. each query statement in the cache plan corresponds to a row in that view .

                                  &N Bsp             and the lifetime of the line is associated with the plan itself.   When you delete a plan from the cache, the corresponding row is also removed from the view.

Select Sqltext.text,stt.creation_time,stt.total_logical_reads,stt.total_logical_writes,stt.total_physical_reads
From sys.dm_exec_query_stats as STT cross apply Sys.dm_exec_sql_text (Stt.sql_handle) as SQLText
Go

SQL Server finds the statements that deserve optimization