SQL Server Performance Forum – Threads Archive
XML Stored ProceduresI found the following comments in BOL…
If any one comment more on the performance and memory issues with XML Stored Procedures will be really appreciated… From BOL:
A parsed document is stored in the internal cache of SQL Server 2005. The MSXML parser uses one-eighth the total memory available for SQL Server. To avoid running out of memory, run sp_xml_removedocument to free up the memory. The XML parser invoked by sp_xml_preparedocument can parse internal DTDs and entity declarations. Because maliciously constructed DTDs and entity declarations can be used to perform a denial of service attack, we strongly recommend that users not directly pass XML documents from untrusted sources to sp_xml_preparedocument. To mitigate recursive entity expansion attacks, sp_xml_preparedocument limits to 10,000 the number of entities that can be expanded underneath a single entity at the top level of a document. The limit does not apply to character or numeric entities. This limit allows documents with many entity references to be stored, but prevents any one entity from being recursively expanded in a chain longer than 10,000 expansions. Any comments ???
Guys any comments… MohammedU.
I guess the suggestions in BOL are telling by themselves. And you don’t see too many XML-related postings here.<br /><br />[<img src=’/community/emoticons/emotion-4.gif’ alt=’‘ />]
Thaks, I asked on of my friend to post this question in MS internal email…
I got some more info…