last ran query in sql server

See more:

SQL-Server

hi,

I execute the follwing query.

SELECT deqs.last_execution_time AS [Time], dest.TEXT AS [Query],
	dess.host_name as 'Host Name'
	FROM sys.dm_exec_query_stats AS deqs
	CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest 
	cross apply sys.dm_exec_sessions dess
	where deqs.last_execution_time BETWEEN DATEADD(dy, -3, GETDATE()) AND
	GETDATE() and 
	dest.text like 's%' and dess.session_id = @@spid
	ORDER BY deqs.last_execution_time DESC

it will execute successfully. But when server restart the executed queries are clear.
how can i cache that queries.

can you please help me.

thanks in advance.