为什么 SQL Server 中的分布式事务不支持快照隔离 [英] Why isn't Snapshot isolation supported with Distributed Transactions in SQL Server

问题描述

问题在标题中.我只是想了解为什么不支持此功能?

Question is in the title. I'd just love to understand why this isn't supported?

只是为了澄清这是 MS Sql Server 2005/2008.

Just to clarify this is MS Sql Server 2005 / 2008.

推荐答案

因为它可能不一致，而且开箱即用比基于锁的隔离 (ANSI SQL) 更弱.

Because it's potentially inconsistent and it's weaker out of the box than lock-based isolation (ANSI SQL).

或者，缺点(例如这个银行业务示例)需要更多的工作和考虑让事情保持正确，所以不支持它更安全.

Or, the downsides (such as this banking example) require more work and thinking to keep things correct so it's simply safer not to support it.

最后(我没查过)，是在ANSI标准中吗?这可能是一个非常定制的解决方案，您将无法在其他平台上使用分布式事务

Finally (I've not checked), is it in the ANSI standard? It could be a very bespoke solution and you'd be unable to use distributed transactions against other platforms

链接 1

这篇关于为什么 SQL Server 中的分布式事务不支持快照隔离的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！