sys.dm_exec_cached_plan_dependent_objects (Transact-SQL)

Applies to: SQL Server (all supported versions) Azure SQL Database Azure SQL Managed Instance

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

Diagram of physical joins for sys.dm_exec_cached_plan_dependent_objects.

Relationship cardinalities

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

Next steps

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