sp_xml_preparedocument: uses one-eighth the total memory

Question

 

Hi

I want to understand one thing: there some text in msdn for sp_xml_preparedocument

===

The MSXML parser (Msxmlsql.dll) uses one-eighth the total memory available for SQL Server

===

I understand this so: when parser works it uses up to of "one-eighth" the total memory. By another words if shorter xml document was parsed, MSXML uses as much memory as it need in this moment (maybe much less than maximum), but not greater than "one-eighth". Am I right?

 

Or this must be undersood that MSXML always uses its maximum of "one-eighth" the total memory, whatever xml document is parsed?

 

Thanks in advance

Answer 1

It's the maximum memory the parser can use, whatever the size the xml document is. So you may get an error message:

XML document could not be created because server memory is low. Use sp_xml_removedocument to release XML documents

Answer 2

phe wrote:

It's the maximum memory the parser can use, whatever the size the xml document is.

 

Surely I understand this. I am interested with another: whether the parser will use much less memory if the xml document is very small? Or it will ALWAYS use one-eighth the total memory available to SQL server?

Answer 3

Really noone knows the answer on this question?

Answer 4

MSXML does not reserve all of the memory available to it at once. The memory usage depends on the documents being parsed.

 

Regards,

Galex