Anil-465177 (10/19/2009)
However, it consumes a lot of cpu cycles to read the xml data as SQL is not natively optimized for XML.
Nonsense. SQL Server contains many optimizations for generating and consuming XML. A well-designed system can process XML extremely efficiently. I seem to keep mentioning Service Broker recently, but it is an excellent example of how well an XML-message-based system can scale out and up.
Anil-465177 (10/19/2009)
We have high CPU usage under high volume transactions, causing slow response times.
No doubt. 😉
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi