/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

31 votes128 views3 answers
SQL Server change column data type
SQL
0 vote125 views1 answer
Install sql server in ubuntu 20.04
SQL
9 votes273 views2 answers
Current date in postgresql minus 1 day
SQL
3 votes134 views3 answers
Mysql declare variable
SQL
1 vote119 views3 answers
How to truncate foreign key constraint table
SQL
44 votes239 views4 answers
Mysql alter table add column first
SQL
3 votes152 views2 answers
How to modify rows in SQL Server
SQL
0 vote128 views1 answer
How to update date value in sql
SQL
0 vote169 views1 answer
Sql check if field is not null
SQL
0 vote121 views1 answer
Acual month sql
SQL