d Gives you information about any sessions that are using xml documents, including stats about the XML document and usage. You can also get the statements that were used to create the XML handle using sys.dm_exec_sql_text to get the sql. Type: Function
Read More...