sys.dm_exec_cached_plan_dependent_objects (Transact-SQL)
Returns a row for each Transact-SQL execution plan, common language runtime (CLR) execution plan, and cursor associated with a plan.
Note
For Transact-SQL execution plans, the sys.dm_exec_cached_plan_dependent_objects table-valued function maps to the syscacheobjects system table in SQL Server 2000.
Syntax
dm_exec_cached_plan_dependent_objects(plan_handle)
Arguments
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:
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) |
Possible values are
Column is not nullable. |
Permissions
Requires VIEW SERVER STATE permission on the server.
Physical Joins
.gif "Relationship diagram")
Relationship Cardinalities
From |
To |
On |
Relationship |
|---|---|---|---|
dm_exec_cached_plan_dependent_objects |
dm_os_memory_objects |
memory_object_address |
One-to-one |