• 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. 😉