Questions tagged [availability-groups]

Availability Groups are a new feature of SQL Server 2012 that provide continuous data synchronization, automatic failover and secondary read access for one or many SQL Server databases.

Filter by
Sorted by
Tagged with
1
vote
1answer
22 views

Upgrading SQL 2016 AGs to SQL 2019 question

I am doing a rolling upgrade of my production SQL 2016 Servers to SQL 2019. I have availability groups. My current structure is 3 DR servers (secondaries), 3 HQ (on prem) secondaries and 3 HQ ...
0
votes
1answer
15 views

Web server accessing the database server in Always on availability group

We have a web server that is on the DMZ but that will need to query a database that resides inside the network. Now the network team wont allow port 1433 from the web server to the Database server. ...
1
vote
1answer
45 views

Troubleshooting slow connection establishment

The client and the server are running on Windows on different subnets. I'm facing a 20s delay to establish a connection to a SQL 2012 Always On availability group using .NET Core Sql client using sql ...
0
votes
1answer
16 views

activate Service Broker on a database in an Availability Group

I found some older posts dealing with this(5 yrs old or more), but I am confused on the process or if this information is out of date, hence my new question. I am on sql 2016 SP2-CU11 enterprise. I ...
2
votes
1answer
27 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 ...
0
votes
0answers
18 views

Non-Domain Account Error while Creating Availability Group

I am creating Availability Group with two node cluster. Both servers are using same service account for SQL. But, while creating Availability Group, I getting that the SQL service account is using non-...
0
votes
0answers
10 views

Difference between AlwaysOn with 'WSFC' as the Cluster Type and 'AlwaysOn Failover Clustering'?

Per what I understood: Clustering is used for HA, where you can failover automatically, and it should be fast since the DB files are in a shared disk, so it would just be “reconnecting” the disk to ...
2
votes
1answer
34 views

log send queue size and redo queue size in AG

I am trying to figure out the way to monitor these 2 events log send queue size - I can see this in perfmon Redo queue size - I can see in dmv but not in perfmon counter Is there any way of using ...
2
votes
2answers
25 views

Can 'clustering' and 'alwayson failover clustering' be used interchangeably?

I am reading this summary from the book 'Pro SQL Server 2019 Administration' from Carter. In 'hot', when citing the examples the author writes 'Clustering'. But when each technology is explained it ...
0
votes
2answers
35 views

Always On Synchronous Commit Mode With Large Delays [duplicate]

For SQL Server Enterprise's Always On availability groups in Synchronous Commit mode, is there some amount of latency that can't be exceeded? For example, can it work between very distant data ...
3
votes
1answer
38 views

Azure Readable Secondary - How to: Different Access Policy to Primary?

We have primary databases. They are in a mix of elastic pool, and standalone. We have successfully created active geo replicated secondaries. (Our use for these is solely workload isolation.) We want ...
0
votes
1answer
44 views

Timeout for Always On Synchronous Commit Mode

For SQL Server Enterprise's Always On availability groups, how can you configure the timeout for Synchronous Commit mode? Is there a maximum? Can it work, for example, between continents? Thanks
0
votes
1answer
14 views

Can we configure local and azure servers in a WSFC for Always On Availability Group? [closed]

Can we configure a local server and an azure server as a two node cluster for Always on Availability Group? Thanks!
0
votes
0answers
11 views

AlwaysOn Availability listener access issue

Good morning all , Who has any idea how to do create an SQL alias on a listen alwayson which uses a port other than 1433 thanks
2
votes
1answer
46 views

How does Automatic Seeding work - Always On Availability Group

I found only these two statements from BOL regarding this Initial Data Synchronization method: Link 1 Automatic seeding uses the log stream transport to stream the backup using VDI to the secondary ...
0
votes
1answer
52 views

log_reuse_wait_desc - AVAILABILITY_REPLICA Unable to truncate transaction log

I have just 1 secondary replica and just one database in my availability group. Both Primary and Secondary replicas are in synchronous-commit availability mode. I inserted 1000 records into the table ...
0
votes
0answers
25 views

Did user connect via AG Listener or directly to the server? [duplicate]

How do I tell whether a SPID connected via the AG Listener name or the server name (or its IP address)?
0
votes
1answer
13 views

What is difference between Lease Timeout and HealthCheck Timeout in AlwaysON?

this question was asked twice here but still there is no satisfied answer. Could someone explain the main difference between these two timeouts?
0
votes
1answer
24 views

Stop seeding process in the AG

In my scenario I have 2 databases I would like to add into my AG. I have initiated it via automatic seeding, but then deleted one DB from the AG pool. As a result I expected it will stop the seeding ...
1
vote
1answer
34 views

Database distribution in AlwaysOn

Good morning all, I have an on Always On SQL server configuration where transactional replication is configured If I open SSMS I find that the distribution database is set to AlwaysOn on then I cannot ...
1
vote
2answers
30 views

Availability Group Listener and old client software

We've got a multisegment AG Listener named SQLAGL01 which points to these two addresses: 10.143.162.32 (the primary server) 10.140.165.32 (DR server) Because the 3rd party (which means we can't fix it,...
0
votes
0answers
26 views

Disconnected replica when recovering from a forced failover

I'm evaluating disaster recovery using read-scale availability group on SQL Server 2019 and Windows 2019. The cluster type is NONE. The cluster works fine in general even when restarting replicas. The ...
0
votes
0answers
21 views

Nonclustered index corruption resulting in minidump - what could be the reason? (SQL Server 2017 CU21)

So today i received alerts from our AlwaysOn cluster about replica failover. After investigating the case, looking through sql logs, cluster logs, xe sessions i found out that prior to the failover ...
0
votes
0answers
21 views

SQL Server 2016 Altering avaibilty group listener IP

I cannot find the right method/way/syntax to change my IP listener address on an Always On availability group under SQL Server 2016. I have a listener, myldag on port 1433 IP 150.1.2.3 and I want to ...
0
votes
1answer
26 views

SQL Server Automatic Tuning (for query plans) vs. Availability Groups

In SQL Server 2017 (and up), for a database configured within an Availability Group, with query stored enabled, will automatic tuning work on the read-only replicas? I don’t think so, because query ...
0
votes
0answers
16 views

Domain Independent Cluster Error “Cluster network name resource…”

Windows Server 2019 SQL Server Standard 2019 3 Basic AG with listeners Setup: I have a domain-independent two-node cluster with a file share witness. Our nodes are not joined to a domain. I ...
1
vote
1answer
43 views

Index maintenance for AG DBs

I wanted to get some opinions on the index maintenance we currently do at the company where I work. One of our production SQL 2012 clusters that consists of 4 nodes, with two instances on each, has ...
0
votes
0answers
15 views

SQL Server Always On in EC2\AWS - Add new replicas how to?

Can someone please answer on this. we have 2 node WFC with AG group + listener listed to secondary IPs in AWS. one replica in AZ1, another in AZ2. Now due to perf issues the users added two more nodes....
0
votes
0answers
20 views

How to renew certificates in an availability group without downtime?

OK, here is the setup. We have two nodes, both running SQL Server 2016, participating in an availability group. Both servers are running on Windows Server 2016 and are NOT joined to an Active ...
3
votes
2answers
206 views

SQL Errorlog Constant FlushCache Messages

A server that is part of a SQL 2017 Always on availability group (BAG) I have noticed an increase of these messages. I understand these are messages that appear in the log as standard since 2012 (...
0
votes
1answer
13 views

Can I have a sql 2017 read-scale AG on different Windows server OSs; i.e. Windows server 2016/2019?

I hope the title is self-explanatory. We want to add another node to our sql server 2017 read-scale AG. I would like to go with Windows server version 2019, and cannot find any information that says I ...
0
votes
1answer
26 views

Multiple Instances in AlwaysOn Availability Groups - Resource Balancing

I have 2 SQL 2017 Instances on each node in a 2 node cluster with a file share witness. 8 cores and 64GB RAM on each. Node A acts as the primary for Instance 1 and Node B acts as the primary for ...
0
votes
0answers
16 views

SQL AOAG QUORUM clarification

Setup: SQL AOAG(SQL ALways On Availability Group) PDC(Primary Data Center) has 2 Nodes(PDCDB01 and PDCDB02) DRC(Disaster and Recover Center) has 1 Node(DRDB01) FSW(File Share Witness) Quorum ...
0
votes
2answers
30 views

SQL Replication using Two Availability Group

Is it possible to setup SQL Replication with Two Availability Group Cluster? one is Publisher(or Distributor if not in different server) and the other AG is Subscriber?
0
votes
0answers
31 views

SQL Server Availability Groups and CDC

I have a simple SQL Server 2014 Availability Group, one database on a two-node cluster. We need to use CDC to move data to another environment, in my case AWS. This is a super-critical OLTP very large ...
0
votes
1answer
27 views

How do I dictate the order of preferred replica on a Always On cluster?

I have a problem, I look after a massive estate. the newer AO clusters I built myself and they work fine. I have inherited once AO cluster which is often problematic. However, migrating isn't an ...
1
vote
2answers
33 views

SQL server AlwaysOn alternate option for readintent=true

I know applications need certain(newest) version of ODBC drivers to connect an AlwaysOn SQL instance replica and to use the option "applicationIntent= readonly" Now my question is , if some ...
0
votes
0answers
17 views

Availability Group Performance [duplicate]

If I give a user the rights to read on my secondary replica which is in sync (not async) with primary replica, and if that user runs a query with a lot of Select into ##Temptable statements on the ...
0
votes
0answers
21 views

SQL Failover and Failback Script for SRM Recovery Plan(preferably power shell or CMD or Batch script)

OS: Windows Server 2016 Standard SQL: SQL Server 2016 Enterprise SQL Setup: Two Nodes(Primary and Secondary Node) in PDC(Primary Data Center) having Always On Availability Group with Synchronous Mode ...
0
votes
1answer
29 views

TempDB Version Store used by DB STARTUP background process

I have two availability group on the same SQL Server 2012 Instance (synchronous commit). Trace flags 1118 and 1117 are both enabled. TempDB has been growing for about two weeks: it starts from 36GB ...
-1
votes
1answer
33 views

SQL alwayson AG Disaster Recovery

Need advise on below: I have 2 node alwayson AG on Primary Sync mode in the current configuration and fsw is in Primary DC only Actually during Switchover the entire DC 2 node and fsw will be down ...
0
votes
0answers
24 views

SQL Replication Subscriber with AlwaysON setup

We have 2 AlwaysON cluster and we want that to set up as a SQL Replication server which is the Always-on Cluster 1 is the Publisher and Always-on Cluster 2 is the SUBSCRIBER, my question is it ...
0
votes
1answer
29 views

Automatic Failover At Always On High Avability Group SQL SERVER

after i read on documentation https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/failover-clustering-and-always-on-availability-groups-sql-server?view=sql-server-ver15 i ...
0
votes
1answer
27 views

MS SQL Server 2016 - Always On Node-2 Stuck In Resolving State

For testing the Always On structure; we suddenly shut down the machine on which Node-1 was running. So we wanted to see that Node-2 turns primary. However, Node-2 was stuck in resolving mode. 3 ...
0
votes
0answers
12 views

How to setup transaction in partitioned table with Always On?

I am currently creating a project that will use a table that will contain around 40 columns (including varchar (max)) and will be partitioned. About 200-250 records per second are to be inserted into ...
0
votes
0answers
12 views

Copy DWH for reports

I have a heavy load DWH server. I wish to create a copy of that server for report purposes (Cognos reports to be exact). In today's situation I have many reports and can cause locks on other processes,...
0
votes
0answers
40 views

Cannot connect after Availability Group automatic failover

We have a SQL Server setup with Availability Groups, in the cluster we have four nodes, two in one datacenter and two in another datacenter. There are four AGs on these cluster nodes, each primarily ...
1
vote
1answer
25 views

Why did full backup file size grow after data movement for Availability Group replica was suspended?

Found an error log informing that data movement to a secondary availability replica was suspended. I'm not sure whether the cause of the suspension is relevant to answering my question, but the cause ...
0
votes
1answer
20 views

How to do failover between AG setup for FCI-FCI servers

Hope I can portrait my question well because i really get confused with AG's :) We have the setup like below- Windows cluster WKCLU01 with 4 nodes (Node1,2,3,4) and a file share witness in DC3, total ...
-1
votes
1answer
34 views

Power shell script for failover from primary to DR

SQL server version is SQL Version 2016 Current setup is two nodes in primary having always on availability group. Adding a 3rd node which is DR(Disaster and Recover). Does anyone knows a power shell ...

1
2 3 4 5
25