Search notes:

SQL Server: sys.dm_* functions

select
   obj.name
from
   sys.schemas         sch join
   sys.all_objects     obj on sch.schema_id = obj.schema_id
where
   sch.name      = 'sys'             and
   obj.type_desc = 'SQL_INLINE_TABLE_VALUED_FUNCTION'            and
   obj.name like   'dm_exec%'
order by
   obj.name
dm_exec_cached_plan_dependent_objects
dm_exec_cursors
dm_exec_describe_first_result_set
dm_exec_describe_first_result_set_for_object
dm_exec_input_buffer
dm_exec_plan_attributes
dm_exec_query_plan
dm_exec_query_statistics_xml
dm_exec_sql_text Get the text of an SQL batch, given its SQL handle.
dm_exec_text_query_plan
dm_exec_xml_handles

Index