70-433 · Question #16
Your company uses an application that passes XML to the database server by using stored procedures. The database server has a large number of XML handles that are currently active. You determine…
The correct answer is A. sp_xml_removedocument. sp_xml_removedocument removes the internal representation of the XML document specified by the document handle and invalidates the document handle. sp_xml_preparedocument reads the XML text provided as input, parses the text by using the (Msxmlsql.dll), and provides the parsed…
Question
Your company uses an application that passes XML to the database server by using stored procedures. The database server has a large number of XML handles that are currently active. You determine that the XML is not being flushed from SQL Server memory. You need to identify the system stored procedure to flush the XML from memory. Which Transact-SQL statement should you use?
Options
- Asp_xml_removedocument
- Bsp_xml_preparedocument
- Csp_reserve_http_namespace
- Dsp_delete_http_namespace_reservation
How the community answered
(14 responses)- A79% (11)
- C7% (1)
- D14% (2)
Explanation
sp_xml_removedocument removes the internal representation of the XML document specified by the document handle and invalidates the document handle. sp_xml_preparedocument reads the XML text provided as input, parses the text by using the (Msxmlsql.dll), and provides the parsed document in a state ready for consumption. This parsed document is a tree representation of the various nodes in the XML document: elements, attributes, text, comments, and so on. A parsed document is stored in the internal cache of SQL Server. The MSXML parser uses one-eighth the total memory available for SQL To avoid running out of memory, run sp_xml_removedocument to free up the memory.
Topics
Community Discussion
No community discussion yet for this question.