Skip to main content

Questions tagged [distributed-availability-groups]

A variation of the existing AOAG feature that connect AGs in two or more clusters. Distributed Availability Groups are a new feature in SQL Server 2016.

Filter by
Sorted by
Tagged with
0 votes
0 answers
21 views

Manual Failover of SQL Server Distributed Availability Group

Is anyone able to kindly shed some light on an issue for me please? I have two Distributed Availability Group environments, one is SQL 2019 and the other is SQL 2022. The SQL 2019 environment is fine, ...
PTL_SQL's user avatar
  • 341
0 votes
0 answers
28 views

Configure multiple instances on a SQL Availability group cluster

I need some guidance please. My Distributed AG configuration is to be with: Two SQL 2022 named instances each with its own AG and AG listener on the Primary Cluster hence two DAGs on the one cluster ...
PTL_SQL's user avatar
  • 341
1 vote
1 answer
80 views

How to determine the global primary instance in a SQL Server distributed availability group using T-SQL?

I have a SQL Server distributed availability group set up, and I'm currently connected to the forwarder instance. I would like to know how to use T-SQL to query the appropriate DMVs or catalog views ...
Just a learner's user avatar
0 votes
1 answer
42 views

Can a SQL Server Distributed Availability Group be between AGs in different Active Directory Domains?

Three questions please: Can we have a single DAG across 3 WSFC clusters i.e. spanning 3 AGs? If so, is it possible to configure it such that two AGs are in the same Active Directory domain while a ...
PTL_SQL's user avatar
  • 341
0 votes
1 answer
97 views

SQL Server Assertion error On Availability Groups

We are having constant memory dumps from our SQL 2019 cu21 instance. We upgraded this instance to cu26 (latest patch) hoping this can resolve the issue but it did not. The error log is filled with ...
SqlData's user avatar
  • 39
0 votes
1 answer
79 views

Removing specific databases from a secondary Availability Group in a Distributed Availability Group setup

I recently set up a Distributed Availability Group (DAG) between an existing on-premises Always On Availability Group (AG) and a new AG in AWS. The on-premises AG serves as the primary, while the AWS ...
Just a learner's user avatar
0 votes
1 answer
44 views

Creating a SQL Server Distributed Availability Group across two Availability Groups on the same instances

I have a scenario where I want to create a SQL Server Distributed Availability Group (DAG) that spans across two existing Availability Groups (AGs) residing on the same set of SQL Server instances. ...
Just a learner's user avatar
0 votes
1 answer
39 views

Can a SQL Server Distributed Availability Group have multiple secondary replica Availability Groups?

I have a question regarding the configuration of SQL Server Distributed Availability Groups (DAGs). I understand that a DAG is used to replicate data from one Availability Group (AG) to another. ...
Just a learner's user avatar
0 votes
1 answer
34 views

Configuring Distributed Availability Group with multiple SQL instances

I am trying to create multiple SQL instances each with its own AG (and listener) on 2 Windows clusters in a Distributed AG as follows: Two sites - Primary & DR Each site has a WSFC configuration ...
PTL_SQL's user avatar
  • 341
0 votes
1 answer
84 views

Multiple SQL Server instances each with one Availability Group on one Cluster of two nodes in a DAG configuration

I'd appreciate some advice please. I am about to get to work on implementing a SQL 2019 Distributed Availability Group configuration with following architecture: Two sites - one primary & one DR ...
PTL_SQL's user avatar
  • 341
0 votes
1 answer
99 views

Help Needed: Setting Up a Distributed Availability Group with Manual Seeding in SQL Server

Hello SQL Server Experts, I'm in the process of configuring a Distributed Availability Group (DAG) in SQL Server and am looking for guidance on implementing it with manual seeding (back up restore) ...
Just a learner's user avatar
0 votes
0 answers
61 views

Why Bytes Sent to Transport/sec is different on different replicas?

I am troubleshooting latency for a specific replica in a Distributed AG setup (with 2 remote replicas). Looking at perfmon I see clear indication as to why one replica shows delay. I see Bytes Sent to ...
GAURAV RATHOD's user avatar
0 votes
0 answers
279 views

When I connected SQL Server 2019 Management Studio Connection to Integration Services it shows me Error Class Not Registered

I'm installed SQL Server 2019 Enteprisse in the first server and I have other server with SQL Server 2019 Standar Edition ,both server when I tried connect with the Integration Service SQL server 2019 ...
Kalusql's user avatar
0 votes
1 answer
41 views

Why log_send_queue_size spikes all of sudden?

Environment details: SQL Server 2019 (CU 19) - 96 logical processors, 1.5 TB RAM Hosting 1 database of 3 TB I have distributed availability group (async) setup which spans across two datacenters. Both ...
GAURAV RATHOD's user avatar
0 votes
0 answers
149 views

How to activate MSDTC for SQL Server 2019 failover cluster

I have configured a failover cluster and always on SQL Server 2019 high availability group on 2 nodes and operating system with Windows Server 2019. I am trying to configure the MSDTC properties of ...
Kalusql's user avatar
0 votes
1 answer
356 views

How do I modify session timeout on a replica for a Distributed Availability Group?

I have a Distributed Availability Group in my production environment that occasionally has a timeout. When it does I get the following message in the AlwaysOn_health on the forwarder: A connection ...
user3593990's user avatar
0 votes
1 answer
92 views

How do I identify what appears to be a CPU bottleneck within SQL Sever?

I have virtual machines on two different types of hosts (vmware). Host type A has CPUs with a clock speed of 2.09GHz Host type B has CPUs with a clock speed of 2.69GHz All other resources are the same ...
Eta_Argus's user avatar
0 votes
1 answer
20 views

Can I distribute a distributed availability group?

Server1 and Server2 make up a NEW availability group: AGServer. DMZ1 and DMZ2 already make up an existing availability group: AGDMZ. Currently DMZ1 & DMZ2 are part of a Distributed Availability ...
CrushingIT's user avatar
6 votes
1 answer
566 views

Distributed Availability Groups refusing to resync my FILESTREAM database with SUSPEND_FROM_CAPTURE

My home lab setup consists of four servers running in HyperV across two physical hosts. The SQL Server instances are SQLAG101, SQLAG102, SQLAG201, and SQLAG202. SQLAG101 and SQLAG102 are members of ...
Hannah Vernon's user avatar
  • 70.2k
0 votes
1 answer
86 views

Distributed AG to migrate from SS2016 to SS2019

I am planning on migrating from SQL Server 2016 AG1 running on WSFC 2012 to SQL Server 2019 AG2 running on WSFC 2022. I want to use using Distributed AG to minimize downtime. is this scenario without ...
Benny Lopez's user avatar
0 votes
1 answer
59 views

Distributed Availability group with witness server for quorum

I have experience in setting up availability group and have used witness server when the nodes are even to achieve quorum. One of the vendor provided a layout which will have two availability group ...
SQL_NoExpert's user avatar
  • 1,061
0 votes
1 answer
224 views

Multiple Distributed Availability Groups

Say we have 3 availability groups DB1-AG, DB2-AG, DB3-AG. According to the Docs, we can create distributed availability groups [DB1-AG, DB2-AG] and [DB2-AG, DB3-AG]. Where DB1-AG is a primary ...
Ryuu's user avatar
  • 103
0 votes
1 answer
87 views

How to extend Distributed availability groups to another datacenter

Actually I have a Distributed availability groups with SQL Server 2016 configured like this: The endpoint are configured like this: USE [master] GO CREATE ENDPOINT [endpoint_istance2] STATE=...
user_0's user avatar
  • 1,023
2 votes
3 answers
728 views

What affects log_send_rate in Normal or Distributed AG other than OS resources?

I am observing low log_send_rate in my distributed AG setup. I understand that AG uses log stream and so I assume it should not have anything to do with data, but I was wondering if this has anything ...
GAURAV RATHOD's user avatar
0 votes
2 answers
739 views

Backup on Distributed AG setup

I have setup a distibruted availability group and trying to understand behaviour of backups on it. While I can take backup from primary replica of Primary AG, I can not take backup from primary ...
GAURAV RATHOD's user avatar
1 vote
1 answer
916 views

SQL Server Distributed Availability Group databases not syncing after a Global Primary Replica Failover

SQL Server Distributed Availability Group Environment AG1 => Node1 (AG1-Global Primary) and Node2 (AG1 - Secondary Replica) AG2 => Node3 (AG2-Forwarder) and Node4 (AG2 - Secondary Replica) DAGE ...
HvyOnEz Solid-Ground's user avatar
0 votes
1 answer
68 views

Can Availability Group be configured in a below structure?

I have Production and DR clusters as depicted on a picture below. My question is whether there is a way to configure Availability Group from datacenter1 to datacenter2? I tried to configure regular ...
Serdia's user avatar
  • 697
1 vote
1 answer
165 views

Is Log stream compression enabled by default for asynchronous replicas in Distributed Availability groups as well?

I am seeding a database using distributed availability group. Seeding is automatic but synchronization mode is asynchronous. Log stream compression for automatic seeding is NOT enabled via TF 9567. ...
GAURAV RATHOD's user avatar
2 votes
1 answer
633 views

Remove database from Distributed Availability Group replica AG ONLY!

all! I have an existing always on availability group on-prem and last week created a second one in AWS. After that, I created a distributed availability group with on-prem as primary and AWS as the ...
calmkza's user avatar
  • 21
0 votes
1 answer
689 views

Failover and Failback SQL server Distributed availability group with different versions

I know that SQL server Distributed availability groups can sync data between two different Major versions, Lets say Global Primary - 2016 Secondary AG - 2017 This sync will work and I can do failover ...
TheDataGuy's user avatar
  • 1,950
0 votes
2 answers
83 views

SQL server 2017 distributed availability group connectivity after failover

I'm going to deploy SQL server distributed availability groups with SQL server 2017. From the documentation, I understand that we can have listeners for primary AG and secondary AG. The application ...
TheDataGuy's user avatar
  • 1,950
1 vote
1 answer
411 views

How to Reconnect Apps to a Different Listener in a SQL Server Distributed Availability Group

I have created a SQL Server Distributed Availability Group (AG), which spans two underlying AGs, each of them deployed on a Windows Cluster at a different location. I have also created a Listener for ...
JF0001's user avatar
  • 163
0 votes
0 answers
50 views

Failing Over on the Fisrt SQL Server AG at one Location breaks the Distributed AG at the Second Location

I have configured a SQL Server Distributed Availability Group (AG), containing a Windows cluster with an AG at one location, and a second cluster with its own AG at another location (thus, two AGs). ...
JF0001's user avatar
  • 163
0 votes
1 answer
60 views

SQL Server Installation for a Distributed Availability Group

I am deploying a SQL Server 2019 Distributed Availability Group. I have created a WSFC at each of my two sites (spanning two servers each). Upon installing SQL Server, it is not clear to me if I ...
JF0001's user avatar
  • 163
0 votes
1 answer
74 views

Are Quorums necessary in a SQL Server Distributed Availability Group

I am creating a SQL Server 2016/2019 Distributed Availability Group, which will host 2 AGs (one at one location and another at a different location). Do I need to create a Quorum for each of the 2 ...
JF0001's user avatar
  • 163
1 vote
1 answer
488 views

LISTENER_IP = ALL not working

I try to create an endpoint specifying to listen on any IP: CREATE ENDPOINT [Hadr_endpoint] AS TCP ( LISTENER_PORT = 5022, LISTENER_IP = ALL ) FOR DATABASE_MIRRORING ( ...
Fran Amat 's user avatar
4 votes
2 answers
512 views

MS SQL 2017 cluster: impact of disabling distributed transactions for an availability group

A company is having a Microsoft SQL Server 2017 Enterprise cluster (RTM-GDR, 64-bit, 14.0.2027.2, KB4505224) consisting of one Availability Group (AG) with two servers, a primary and a secondary. A ...
Arthur Borsboom's user avatar
1 vote
1 answer
254 views

Sync logins and Agent jobs across all replicas in Distributed Availability Group

I am using dba_CopyLogins stored proc to sync logins on replicas in Distributed Availability groups, but the database level permissions are not transferred due to database sync operation is going on.. ...
kpx's user avatar
  • 11
-1 votes
1 answer
2k views

How to find the distribution of star ratings to the business in the following cities? (SQLITE) [closed]

select stars from business where city = 'Avon'; Data: +-------+ | stars | +-------+ | 2.5 | | 4.0 | | 5.0 | | 3.5 | | 1.5 | | 3.5 | | 4.5 | | 3.5 | | 2.5 | | 4.0 | +-------+ ...
jitendra sharma's user avatar
2 votes
1 answer
299 views

Upgrade with DistributedAG vs adding a node with SQL Server 2019

We would like to migrate from SQL Server 2016 to SQL Server 2019. The databases are part of an Availability Group. I added a new replica using SQL Server 2019 on a new node and made that replica ...
kevin's user avatar
  • 103
2 votes
0 answers
264 views

Problems with Distributed Availability Group( DAG)

I have 2 servers in AWS Central joined with AWSCentralAG and I have 2 servers in AWS West joined with AWSWestAG. Obviously, I have the listener name and listener IP address and I able to connect to ...
Sid 's user avatar
  • 175
0 votes
2 answers
2k views

Distributed Availability Group between SQL Server 2016 and SQL Server 2019 doesn't seed

Appologies for a long first post :-) I'm planning on implementing a distributed availability group between an existing SQL2016 AG and a new SQL Server 2019 AG, and am validating the design in a LAB ...
Chris's user avatar
  • 1
0 votes
1 answer
247 views

Why distributed AG is preferred to normal AG for cross datacenter failover scenario?

I have two node WSFC and currently I'm working on DR solution with availability group.I already read microsoft doc about distributed AG.So my question is what are benefits of using distributed AG ...
hg1735's user avatar
  • 11
1 vote
2 answers
3k views

Single node availability group - is it possible?

Is it possible to have an availability group with just one node in it? The reason I ask is because I am considering a distributed availability group spanning two single node always on availability ...
Marathon_Nick's user avatar
0 votes
2 answers
37 views

Log file truncation on AG database

I am POCing AlwaysON DAG for my company, and i have come into a very interesting debacle. Seems like even though primary and replica's and all synced up, the log file on the primary DB does not get ...
Uche Okoye's user avatar
0 votes
1 answer
107 views

SQL Server Distributed Availability Group Usage Pattern

I have got a client with DAG setup on 2016 & 2017 servers. I understand that their usage is most likely for DR purposes. What I'm a little unclear on (and I can't find any info on it) is how they ...
user30724's user avatar
4 votes
1 answer
179 views

Distributed AG on SQL Server 2017 Standard Edition?

Can I configure Distributed AG with SQL Server 2017 Standard Edition?
Luis Agustin Azario's user avatar
0 votes
1 answer
92 views

Adding ReadOnly Domain-less replica to existing AG with two replicas on two nodes WSFC

I have AG setup as follows: Multi sub-net WSFC (Windows Server 2016) - All nodes part of same domain AG with two replicas (SQL 2017) - Each node (mentioned above) contains one standalone instance. ...
ymsalem's user avatar
2 votes
0 answers
526 views

Distributed Availability Group Endpoint_URL Setup Question

I have two sites: SiteA and SiteB. Both sites are running SQL Server 2017 Enterprise v14.0.3048.4 on Windows 2012. Both sites are linked with a dedicated VPN connection. We have a series of ...
Alf47's user avatar
  • 961
1 vote
1 answer
6k views

Always On Availability Question mark

In my production environment I have two database Servers know as DBN1 and DBN2. I have made a cluster between two and DBN1 is my primary database server. Now I used Always on availability feature on ...
Mubashar Iftikhar's user avatar