Friday, November 02, 2007 1:05 PM
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
Friday, November 02, 2007 8:54 PMAnswerer
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
Saturday, November 03, 2007 9:02 AM
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?
Wednesday, November 07, 2007 1:09 PM
Really noone knows the answer on this question?
Monday, November 12, 2007 6:36 PM
MSXML does not reserve all of the memory available to it at once. The memory usage depends on the documents being parsed.