DaveWentzel.com            All Things Data

List of DMFs and Purpose

 

 
 
dm_exec_query_plan
returns the XML query plan for a given plan_handle (XML Query Plans)
dm_exec_text_query_plan new in 2005 SP2.  Similar to dm_exec_query_plan but eturns output in text format and allows you to specify individual statements in a batch.  Requires plan_handle and optional start and end offsets. 
dm_db_missing_index_columns
a DMF that returns a table containing a list of suggested columns needed to build the specified missing index. 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Add new comment