Tuesday, March 27, 2012

enumerate prepared xml documents

Is it possible to obtain list of handles returned by
sp_xml_preparedocument?
What I want is to manually release all xml documents allocated by
sp_xml_preparedocument without server restart.
At some point server runs out of memory. We might have bugs in our code(not
calling sp_xml_removedocument) so I want to check if it is actually an issue
of not calling sp_xml_removedocument or may be something else.
Thanks,
Shurik.Hi
Once you should have finished with the document you should call
sp_xml_removedocument to release it. If you don't I do not think there is a
way of doing this without knowing the handle.
John
"Oleksandr Brovko" wrote:

> Is it possible to obtain list of handles returned by
> sp_xml_preparedocument?
> What I want is to manually release all xml documents allocated by
> sp_xml_preparedocument without server restart.
> At some point server runs out of memory. We might have bugs in our code(no
t
> calling sp_xml_removedocument) so I want to check if it is actually an iss
ue
> of not calling sp_xml_removedocument or may be something else.
> Thanks,
> Shurik.
>
>sql

No comments:

Post a Comment