sys.dm_exec_cached_plan_dependent_objects (Transact-SQL)

APPLIES TO: yesSQL Server yesAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

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

Syntax

sys.dm_exec_cached_plan_dependent_objects(plan_handle)  

Arguments

plan_handle
Is a token that 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:

Table Returned

Column name Data type Description
usecounts int Number of times the execution context or cursor has been used.

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

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

Executable plan

CLR compiled function

CLR compiled procedure

Cursor

Permissions

Requires VIEW SERVER STATE permission on the server.

Physical Joins

Relationship diagram

Relationship Cardinalities

From To On Relationship
dm_exec_cached_plan_dependent_objects dm_os_memory_objects memory_object_address One-to-one

See Also

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