/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

14 votes366 views2 answers
Oracle add column with default value
SQL
2 votes355 views1 answer
Column names in oracle sql
SQL
10 votes325 views2 answers
Sql where clause multiple values
SQL
0 vote365 views1 answer
Add a new column into table
SQL
0 vote355 views1 answer
Mysql root permission denied lost
SQL
0 vote368 views1 answer
Sql cnvert bit to nvarchar
SQL
11 votes396 views2 answers
Oracle source code
SQL
0 vote381 views1 answer
Call object contructor and call methods of object
SQL
6 votes338 views1 answer
Postgresql get year
SQL
0 vote365 views1 answer
Stored function in sql
SQL