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.
54
questions
0
votes
0
answers
68
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 ...
- 1
0
votes
1
answer
33
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 ...
- 149
0
votes
0
answers
57
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 ...
- 1
0
votes
1
answer
162
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 ...
- 95
0
votes
1
answer
72
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 ...
0
votes
1
answer
16
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 ...
- 33
6
votes
1
answer
312
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 ...
- 69.7k
0
votes
1
answer
39
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 ...
- 11
0
votes
1
answer
43
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 ...
- 1,039
0
votes
1
answer
133
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 ...
- 103
0
votes
1
answer
78
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=...
- 1,013
2
votes
3
answers
566
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 ...
- 149
0
votes
2
answers
530
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 ...
- 149
1
vote
1
answer
773
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 ...
0
votes
1
answer
64
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 ...
- 657
1
vote
1
answer
128
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. ...
- 149
2
votes
1
answer
523
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 ...
- 21
0
votes
1
answer
497
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 ...
- 1,910
0
votes
2
answers
71
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 ...
- 1,910
1
vote
1
answer
385
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 ...
- 163
0
votes
0
answers
48
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). ...
- 163
0
votes
1
answer
58
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 ...
- 163
0
votes
1
answer
69
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 ...
- 163
1
vote
1
answer
401
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 (
...
- 11
3
votes
2
answers
421
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 ...
- 133
1
vote
1
answer
216
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..
...
- 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 |
+-------+
...
2
votes
1
answer
265
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 ...
- 83
2
votes
0
answers
232
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 ...
- 175
0
votes
2
answers
1k
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 ...
- 1
0
votes
1
answer
194
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 ...
- 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 ...
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 ...
0
votes
1
answer
105
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 ...
4
votes
1
answer
176
views
Distributed AG on SQL Server 2017 Standard Edition?
Can I configure Distributed AG with SQL Server 2017 Standard Edition?
0
votes
1
answer
78
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.
...
- 1
2
votes
0
answers
495
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 ...
- 951
1
vote
1
answer
5k
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 ...
2
votes
0
answers
38
views
Multiple Location AlwaysOn and Azure SQL Server [closed]
AS with the majority of projects, the original scope may not be a viable option. We were using Azure Data Sync and transaction replication to keep the 4 site databases in sync. However, the customer ...
- 21
0
votes
1
answer
726
views
Network Packet Payload Error when Trying to Create Distributed Availability Group
I am attempting to create a distributed AG on SQL 2016 SP1, but keep getting the following errors. I have tried this in a VirtualBox (local desktop) and actual VMWare virtual environment but getting ...
- 21
0
votes
1
answer
907
views
Get DAG members
Via transact SQL with this query:
SELECT ag.[name] as 'AG Name',
ag.Is_Distributed,
ar.replica_server_name as 'Replica Name'
FROM sys.availability_groups ag,
sys....
- 1,013
3
votes
2
answers
992
views
function to check whether the current server is involved in an availability group and if so, whether it is the primary
I used to have 2 servers on an availability group, but there was a problem with one of them servers involved,while patching, and to make a long story short I removed all the databases from the ...
- 15.8k
4
votes
1
answer
1k
views
Mixing SQL Server 2016 and 2017 in a distributed availability group
I have an old Availability Group made up of 2 SQLServer 2016 instances (2 Windows 2016 servers in WSFC)
I also have 2 new SQLServer 2017 instances (2 Windows Server 2016) that I originally wanted to ...
- 43
2
votes
1
answer
273
views
Orphaned Availability Group Name
So I was creating a distributed availability group and noticed I wanted to change the name of the AG so I tried to run DROP AVAILABILITY GROUP. But it was already seeding and was just stuck in "...
- 31
1
vote
1
answer
272
views
Difference between High Availability data synchronization across local replicas and DAG
I see a significant difference when synchronizing data between Primary - Secondary and between Primary HA and Secondary HA as part of Distributed Availability Groups.
The difference in the amount of ...
- 15
11
votes
2
answers
4k
views
Distributed Availability Group with Manual Seeding
I am looking for a step by step walk through of how to setup a distributed availability group with manual seeding. I can get the automatic seeding working but when I try to manually seed I cannot get ...
- 951
2
votes
1
answer
2k
views
List primary replicas and non-HA databases - excluding forwarder replicas
When asking which databases are writable on any given server, I've been using the below snippet to list PRIMARY replica databases and databases that do not participate in an AG.
Now that I've ...
- 4,586
3
votes
2
answers
1k
views
SQL Server - Is there a limit to the number of Distributed Availability Groups that a primary replica can participate in?
The documentation has diagrams with availability groups taking part in multiple Distributed Availability Groups (AG 1, AG 2 and AG 3) take part in Distibuted AG1 ([AG 1, AG 2]) and Distributed AG2 ([...
- 175
1
vote
1
answer
304
views
Configuring Availability group between Two SQL Server Failover Cluster Instances
I am having two Windows clusters. Two SQL cluster instances are there in each two node cluster (
Data centre 1 :Windows Cluster 1-SQL2016CLUS1
Node 1
Node 2
SQL 2016 failover cluster instance1 -...
- 161
0
votes
1
answer
291
views
Error in AG Dashboard when looking at a Distributed AG
I have a Distributed AG, but whenever I go to look at the AG Dashboard it says "An error occurred on the Always On Dashboard". When I click for details I get "Object reference not set to an instance ...
- 3,028