/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

7 votes193 views1 answer
Show line number in sql server
SQL
0 vote157 views1 answer
How to install mysql without admin rights
SQL
0 vote184 views1 answer
How much space does sql server take per row
SQL
-1 vote167 views4 answers
Restart mysql server ubuntu
SQL
0 vote184 views1 answer
Many rows to 1 string mysql
SQL
14 votes183 views6 answers
Finding duplicate rows mysql
SQL
0 vote288 views1 answer
Running mysql from bash sc
SQL
2 votes200 views1 answer
Query to check cpu utilization in oracle database
SQL
0 vote153 views1 answer
Events not working db
SQL
0 vote148 views1 answer
Sql string length postgresql
SQL