Re: openxml performance

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Roger Wolter[MSFT] (rwolter_at_online.microsoft.com)
Date: 06/26/04 

Date: Fri, 25 Jun 2004 19:25:34 -0700

Making the XML smaller might help a little but not a lot. Splitting the
file into smaller files might actually make things worse - there's some
overhead for each DOM created so having the same amount of data spread
around to more DOM's would use more memory. This may help if the smaller
size means the documents get processed enough faster so the total amount of
memory used at a time is reduced. The best thing to do is to reduce the
amount of time the DOM is in memory by rearranging the logic. There are
some cases where increasing memory to leave helps but I don't know if it
will help in your case. 

-- 
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"siddu" <siddu@discussions.microsoft.com> wrote in message 
news:637129A8-A7C5-4C1D-9D27-A9E75640D025@microsoft.com...
> We do lot of xml parsing (OpenXML) and uses SQL Server 2k for our 
> application. Recently we are getting the following error.
>
> SEVERE: Exception in DB call com.jnetdirect.jsql.m: XML document could not
> be created because server memory is low. Use sp_xml_removedocument to
> release XML documents.
>
> We have little more load on our server in the past few weeks. We found few 
> SPs are missing "sp_xml_removedocument" and we added. In general are there 
> any tips on using ? do any of the following helps?
> making the xml size small by keeping the tags small etc., or
> splitting larger xml documents into multiple documents and parsing
> any others please let me know.
>
> is there anyway to monitor the memory used by sql server for openxml?
>
> Thanks.

Relevant Pages

  • Ineeficient Memory Usage
    ... I have an instance of SQL Server 2000 running on Win 2K. ... On it I have a task that runs to decompose xml into tables using ... restarted it sits happily using about 60MB of memory. ...
    (microsoft.public.sqlserver.xml)
  • Re: how to process data when internet connection broken?
    ... keep it in memory using DataSet, but my client don't want to keep recordset ... It is in XML ... >> DataSet) and update the SQL server and local data with the difference. ...
    (microsoft.public.dotnet.faqs)
  • RE: Ineeficient Memory Usage
    ... > When the server is booted or sql server and sql server agent process ... > restarted it sits happily using about 60MB of memory. ... > xml decomposition task the memory gradually creeps up until it hits the ... > and will decompose about 1000 1MB XML files a minute. ...
    (microsoft.public.sqlserver.xml)
  • RE: Ineeficient Memory Usage
    ... > When the server is booted or sql server and sql server agent process ... > restarted it sits happily using about 60MB of memory. ... > xml decomposition task the memory gradually creeps up until it hits the ... > and will decompose about 1000 1MB XML files a minute. ...
    (microsoft.public.sqlserver.xml)
  • Re: memory leak/sp_xml_removedocument
    ... XML document, ... I observed the memory utilization using perfmon. ... I restarted the SQL Server ... > It is not the prepare doc sp that fails, it is one of our sp's, because> there are some xml doc, which are not conform to our expected format. ...
    (microsoft.public.sqlserver.programming)