TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

sys.dm_exec_cached_plan_dependent_objects (Transact-SQL)

 

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)yesAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Returns a row for each Transact-SQL execution plan, common language runtime (CLR) execution plan, and cursor associated with a plan.

  
dm_exec_cached_plan_dependent_objects(plan_handle)  

plan_handle
Uniquely identifies a query execution plan for a batch that has executed and its plan resides in the plan cache. plan_handle is varbinary(64). The plan_handle can be obtained from the following dynamic management objects:

Column nameData typeDescription
usecountsintNumber of times the execution context or cursor has been used.

Column is not nullable.
memory_object_addressvarbinary(8)Memory address of the execution context or cursor.

Column is not nullable.
cacheobjtypenvarchar(50)The Plan cache object type. Column is not nullable. Possible values are

Executable plan

CLR compiled function

CLR compiled procedure

Cursor

Requires VIEW SERVER STATE permission on the server.

Relationship diagram

FromToOnRelationship
dm_exec_cached_plan_dependent_objectsdm_os_memory_objectsmemory_object_addressOne-to-one

Execution Related Dynamic Management Views and Functions (Transact-SQL)
Dynamic Management Views and Functions (Transact-SQL)
sys.syscacheobjects (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft