Udostępnij za pośrednictwem


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.

Składnia

dm_exec_cached_plan_dependent_objects(plan_handle)

Arguments

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

  • Executable plan

  • CLR compiled function

  • CLR compiled procedure

  • Cursor

Column is not nullable.

Permissions

Requires VIEW SERVER STATE permission on the server.

Physical Joins

Diagram relacji

Relationship Cardinalities

From

To

On

Relationship

dm_exec_cached_plan_dependent_objects

dm_os_memory_objects

memory_object_address

One-to-one

Zobacz także

Odwołanie

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

Dynamic Management Views and Functions (Transact-SQL)

sys.syscacheobjects (Transact-SQL)