/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

3 votes438 views1 answer
How to get yesterday date in sql
SQL
0 vote319 views1 answer
Mysql root localhost run
SQL
2 votes302 views1 answer
Sqlite indexes
SQL
0 vote331 views1 answer
Oracle drop type
SQL
41 votes411 views6 answers
Alter table add column in SQL Server
SQL
2 votes312 views3 answers
Postgresql reset auto increment
SQL
0 vote255 views1 answer
Oracle last user logon
SQL
1 vote311 views1 answer
How to make a select in sql
SQL
0 vote315 views1 answer
How to display value of variable in mysql
SQL
0 vote313 views1 answer
Sql server system messeges
SQL