/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 vote209 views2 answers
Many to many flask-sqlalchemy
SQL
0 vote214 views1 answer
TSQL convert csv to table
SQL
0 vote202 views1 answer
Mariadb search columns
SQL
1 vote212 views1 answer
Find a column in all tables postgres
SQL
0 vote251 views1 answer
Time data type in mysql
SQL
2 votes199 views1 answer
Mysql increment value by 1 in update
SQL
10 votes218 views2 answers
Rtrim sql
SQL
0 vote240 views1 answer
Time in sql server
SQL
5 votes214 views1 answer
Oracle list days between two dates
SQL
9 votes209 views3 answers
Oracle undo usage by session
SQL