Transactions
8 TopicsNot-Supported: AGs With DTC/Cross-Database Transactions
First published on MSDN on Jan 06, 2014 When the topic of cross-database and/or DTC transaction support, under an Availability Group, comes up the quick response is NOT SUPPORTED! This is a true statement and the conversation tends to then focus on – ‘but why'?’ In fact, some DBAs have tested various forms of these transaction types and not encountered errors.1.1KViews0likes0CommentsInappropriate usage of high isolation level isn’t just about blocking when it comes to performance
First published on MSDN on Jun 23, 2011 Normally when you see high isolation level such as SERIALIZABLE is used, your natural instinct tells you that it may cause blocking or deadlocking.740Views0likes0Comments