sys.dm_exec_cached_plan_dependent_objects (Transact-SQL)
Applies to: 
SQL Server
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.
Permissions for SQL Server 2022 and later
Requires VIEW SERVER PERFORMANCE STATE permission on the server.
Physical joins
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)