Releasing Memory captured by sp_xml_preparedocument

• TDuffy

  SSCarpal Tunnel

  Points: 4170

  More actions

  July 30, 2007 at 12:15 pm

  #98487

  We are experiencing memory problems using sp_xml_preparedocument.

  The errors are

  WARNING: Failed to reserve contiguous memory of Size= 13631488

  and

  Insufficient memory available.

   

  Investigation shows several stored procedures with sp_xml_preparedocument and without sp_xml_removedocument. Is there any way to free up the memory captured and not released without restarting? If not, does a restart of SQL suffice, or will this require a reboot?

   

  Thanks in advance

  Terry

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  July 30, 2007 at 3:02 pm

  #723421

  Running out memory can be many reasons. We can run something like,

  DBCC FREEPROCCACHE

  Of course, the most efficient approach, but not allowable normally, is to reboot your server.