How to see the values in execution context of a plan ?

  • As per https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2005/administrator/cc966425(v=technet.10)
    multiple execution context exists for a plan and gets reused on the fly .
    But how can we see these execution context similar to query plans using DMVs?
    dm_exec_plan_attributes gives counter for below stuffs only
    inuse_exec_context
    free_exec_context
    hits_exec_context
    misses_exec_context
    removed_exec_context

    On related to above 
    Description for hits_exec_context is given as 
    Number of times the execution context was obtained from the plan cache and reused, saving the overhead of recompiling the SQL statement. The value is an aggregate for all batch executions so far.
    So recompiling is dependent on execution context also ?

Viewing 0 posts

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