Post reply

How can i see if a proc call is using a cached execution plan?

  • February 2, 2012 at 9:00 am

    #391464

    How can i see if a proc call is using a cached execution plan?

  • February 3, 2012 at 5:15 am

    #1442336

    You can look at trace events/extended events for a compile event. You can also check the cache itself using sys.dm_exec_query_stats to see if the use is incremented by one. Also, look at the exec plan properties to see when the plan used was compiled vs. when it was executed.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply