Home Forums SQL Server 2016 SQL Server 2016 - Administration XML Documents using sp_xml_preparedocument and not using sp_xml_RemoveDocument RE: XML Documents using sp_xml_preparedocument and not using sp_xml_RemoveDocument

  • March 8, 2018 at 12:56 pm

    #1982551

    m.fetros - Thursday, March 8, 2018 12:28 PM

    your query have a greater than 8 in it.  I know that each xml document is allocated 1/8th of the memory.  but does that mean only 8 can exist at a time.  Is the 1/8th allocation of total memory, so it is static, or is it 1/8th of available.
    Also, the database I am having problems with is high volume (thousands of concurrent users)  with hundreds or even thousands of transactions a minute.

    It uses 1/8 of the total memory available to SQL Server.  There can certainly be more than 8 of these occurring at the same time.  Which is why you are likely having issues. 

    My question is this.  Would it make more sense to re-write these procedures and eliminate the issue?

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/