question

sandeepkumar198605 avatar image
sandeepkumar198605 asked

How to find the old execution plan

Hi

Can we retrieving old execution plan for a query

ex: query was executed around 2 am, but i need to find the execution plan at 9 am

Thanks

Sandeep

queryexecution planplan
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Kev Riley avatar image
Kev Riley answered

You can look in the plan cache by querying sys.dm_exec_cached_plans, but it may or may not still be there.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.