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.
sys.dm_exec_cached_plan_dependent_objects(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:
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 |
Requires VIEW SERVER STATE
permission on the server.
Requires VIEW SERVER PERFORMANCE STATE permission on the server.
From | To | On | Relationship |
---|---|---|---|
dm_exec_cached_plan_dependent_objects |
dm_os_memory_objects |
memory_object_address |
One-to-one |
Execution Related Dynamic Management Views and Functions (Transact-SQL)
Dynamic Management Views and Functions (Transact-SQL)
sys.syscacheobjects (Transact-SQL)