see the sql_handle under query details under top 10 queries
to find an execution plan in the plan cache when the plan is recreated
15
votes
![](https://secure.gravatar.com/avatar/b9de478abb43ad56852e550c613b934c?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
to find an execution plan in the plan cache when the plan is recreated