Reasons for very high CPU utilization due to XML Reader Table-valued functions?

Ojibwe 2013-09-12 12:57:33

SQLkiwi 2013-09-18 09:33:37
The reason the XML Reader table-valued functions are estimated to use so much CPU is that XML operations are estimated to be CPU-intensive, and the iterators in question are estimated to be executed a large number of times.

Whether the estimate bears any relational to the actual cause of any poor performance you may be experiencing is impossible to say based on an anonymized, complex query plan, with no runtime information.