Fixed by the SQLServerSnapshotIsolationConnectionProvider which allows us to use the Snapshot Isolation MVCC Concurrency Control instead of 2PL during testing.