You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Copy file name to clipboardExpand all lines: docs/database-engine/availability-groups/windows/always-on-availability-groups-interoperability-sql-server.md
+4-3Lines changed: 4 additions & 3 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -2,7 +2,7 @@
2
2
title: "Always On availability groups: interoperability"
3
3
description: "Describes the different features that can and cannot function alongside an Always On availability group."
4
4
ms.custom: "seodec18"
5
-
ms.date: "04/20/2017"
5
+
ms.date: "09/15/2021"
6
6
ms.prod: sql
7
7
ms.reviewer: ""
8
8
ms.technology: availability-groups
@@ -44,7 +44,8 @@ The following table lists [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-m
44
44
45
45
The following features interoperate with [!INCLUDE[ssHADR](../../../includes/sshadr-md.md)] with specific restrictions. See the linked topics for details.
46
46
47
-
- Cross-database transactions/distributed transactions ([!INCLUDE[sssql16-md](../../../includes/sssql16-md.md)] and Windows Server 2016). For more information, see [Cross-Database Transactions and Distributed Transactions for Always On Availability Groups and Database Mirroring (SQL Server)](../../../database-engine/availability-groups/windows/transactions-always-on-availability-and-database-mirroring.md)
47
+
- Cross-database transactions within the same SQL Server instance require [!INCLUDE[sssql16-md](../../../includes/sssql16-md.md)] SP2 and Windows Server 2016 or later, with some patching requirements. For more information, see [Cross-Database Transactions and Distributed Transactions for Always On Availability Groups and Database Mirroring (SQL Server)](../../../database-engine/availability-groups/windows/transactions-always-on-availability-and-database-mirroring.md)
48
+
- Distributed transactions require [!INCLUDE[sssql16-md](../../../includes/sssql16-md.md)] SP2 and Windows Server 2012 R2 or later, with some patching requirements. For more information, see [Cross-Database Transactions and Distributed Transactions for Always On Availability Groups and Database Mirroring (SQL Server)](../../../database-engine/availability-groups/windows/transactions-always-on-availability-and-database-mirroring.md)
48
49
-[Query statistics system data collector](../../../relational-databases/data-collection/system-data-collection-set-reports.md#Query) cannot reliably run in an environment with non-readable secondaries. To use query statistics system data collector, set all secondary availability group replicas to allow [read-access](configure-read-only-access-on-an-availability-replica-sql-server.md).
49
50
50
51
## <aname="NoInterop"></a> Features that Do Not Interoperate with Always On Availability Groups
@@ -71,4 +72,4 @@ The following features interoperate with [!INCLUDE[ssHADR](../../../includes/ssh
71
72
## See Also
72
73
73
74
[Overview of Always On Availability Groups (SQL Server)](../../../database-engine/availability-groups/windows/overview-of-always-on-availability-groups-sql-server.md)
74
-
[Prerequisites, Restrictions, and Recommendations for Always On Availability Groups (SQL Server)](../../../database-engine/availability-groups/windows/prereqs-restrictions-recommendations-always-on-availability.md)
75
+
[Prerequisites, Restrictions, and Recommendations for Always On Availability Groups (SQL Server)](../../../database-engine/availability-groups/windows/prereqs-restrictions-recommendations-always-on-availability.md)
0 commit comments