/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 vote161 views1 answer
Get only structure database mysql
SQL
3 votes136 views4 answers
Order by desc postgres
SQL
2 votes125 views1 answer
Oracle create directory
SQL
0 vote136 views1 answer
Data directory postgresql
SQL
2 votes146 views3 answers
Sql truncate table
SQL
0 vote193 views1 answer
Restart serial number for postgres
SQL
1 vote142 views1 answer
Sqlalchemy order by descending
SQL
0 vote143 views1 answer
Oracle array
SQL
0 vote133 views1 answer
How to find username and password in oracle 18c
SQL
0 vote143 views1 answer
Error Code: 1140. In aggregated query without GROUP BY, expression #3 of SELECT list contains nonaggregated column 'grepper_history.search_history.term'; this is incompatible with sql_mode=only_full_group_by
SQL