Discouraging findings... This was not something I had run into yet on the Receive side because I haven't used the Service Broker implementation with our systems yet, mostly proving message routing etc and happily seeing that things were never promoted to DTC. I did manage to put together a sample doing things as you've described where a connection is opened within a consumer and replied again and it is promoted to DTC. The sending side is a bit different, I read after you raised concerns that SQL Server 2008 does its best to not promote if the connection string is identical. Which is likely why in my second performance test it didn't take a huge performance hit because it was able to run through the entire test without DTC.
Maybe the idea for a non-transactional mode option would be ideal. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Rhino Tools Dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/rhino-tools-dev?hl=en -~----------~----~----~----~------~----~------~--~---
