/SQL/How to get one year old query from plan cache

How to get one year old query from plan cache

SELECT TOP 10
t.TEXT QueryName,
s.execution_count AS ExecutionCount,
s.max_elapsed_time AS MaxElapsedTime,
ISNULL(s.total_elapsed_time / 1000 / NULLIF(s.execution_count, 0), 0) AS AvgElapsedTime,
s.creation_time,
ISNULL(s.execution_count / 1000 / NULLIF(DATEDIFF(s, s.creation_time, GETDATE()), 0), 0) AS FrequencyPerSec
,query_plan
FROM sys.dm_exec_query_stats s
CROSS APPLY sys.dm_exec_query_plan( s.plan_handle ) u
CROSS APPLY sys.dm_exec_sql_text( s.plan_handle ) t
ORDER BY creation_time

Similar codes

0 vote211 views1 answer
Openquery update linked server
SQL
2 votes201 views1 answer
SQLSTATE[HY000] [1049] Unknown database
SQL
0 vote164 views1 answer
Mysql convert column to uppercase
SQL
-2 votes220 views2 answers
Union vs union all in sql
SQL
1 vote213 views1 answer
Mysql get domain from url
SQL
0 vote201 views1 answer
Mysql 1 hour ago
SQL
16 votes203 views1 answer
Mssql int max value
SQL
0 vote203 views1 answer
Mysql count with two joins
SQL
0 vote230 views2 answers
Oracle chain rules
SQL
0 vote205 views1 answer
Postpresql relation not found
SQL