I'm trying to run SQL Tuning Advisor on SQL 2014 and I get the following error.
XML document could not be created because server memory is low. Use sp_xml_removedocument to release XML documents. (Microsoft SQL Server, Error: 6624)
I've read a bunch of articles and they have things like
DECLARE @hdoc INT = 1
EXEC sp_xml_removedocument @hdoc
Which gives back the error "Could not find prepared statement with handle 1."
I have no idea what stored proc has caused this. I have also run
WHERE type LIKE '%XML'; as suggested
I get two results one type is MEMOBJ_MSXML and the other is MEMOBJ_DEADLOCKXML
The server has 700Gb memory 12 CPU.