Provide a way to reclaim the memory lost by absent calls to sp_xml_removedocument by danholmes

Closed

as Won't Fix Help for as Won't Fix

Type:	Suggestion
ID:	776637
Opened:	1/15/2013 4:29:15 PM
Access Restriction:	Public

Workaround(s)

view

BOL states that sp_xml_preparedocument and sp_xml_removedocument should be executed in pairs. That is good but what if there is a bug in the TSQL? The memory is lost and there isn't a complete way to handle the problem.

Details (expand)

English

SQL Engine

provide a parameter to DBCC FREESYSTEMCACHE that would clear this memory. A good choice would be MSXML or MEMOBJ_MSXML. That is how sys.dm_os_memory_objects reports the value.

I have a full blog on this topic here: http://dnhlmssql.blogspot.com/2013/01/what-if-you-dont-call.html

Improved Reliability

0 attachments

Posted by Microsoft on 4/22/2013 at 5:53 AM

Hello,
Thank you for submitting this feedback. After carefully evaluating all of the suggestion items in our pipeline, we are closing items that we will not implement in the near future due to current higher priority items. We will re-evaluate the closed suggestions again in the future based on the product roadmap.

Thanks again for providing the product suggestion and continued support for our product.

Zlatko

Microsoft