Export (0) Print
Expand All

sys.dm_exec_cached_plan_dependent_objects

New: 14 April 2006

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

ms403826.note(en-US,SQL.90).gifNote:
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.


dm_exec_cached_plan_dependent_objects(plan_handle)

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:

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

  • Executable plan
  • CLR compiled function
  • CLR compiled procedure
  • Cursor

Column is not nullable.

Requires VIEW SERVER 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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft