Stored Procedure Cached Execution Plan


  • Is there a way of querying the DMV’s to find out when an execution plan of a stored procedure was cached?

    I had a very slow performing query that I believe has been resolved by the query plan being invalidated and rebuilt but I would like to know for sure if this was the case.

    lundi 6 février 2012 16:16

Toutes les réponses