New answers tagged availability-groups
0
votes
Prevent read access on primary AG replica, but allow it on the readable secondary
A couple of approaches you can try.
Connect the users directly to the secondary without using the AG Listener. A fancy variant of this uses an additional cluster IP endpoint with preferred owner on ...
- 40.6k
0
votes
Prevent read access on primary AG replica, but allow it on the readable secondary
We have this same requirement. I'm curious if the use of an on logon trigger would work?
Create a way to identify which uses are "Read-Only" users:
Grant them a specific role for "Read-...
- 1
1
vote
SQL Server 2019 DAG WFC - Manual Failover won't work (MSSQL Error 41131)
SQL Server error 41131 (see attachment)
and
We double checked every possible problem, but we cannot get managed, to manual failover an AvailabilityGroup with a synchronized DB via SSMS
Error 41131 ...
1
vote
New DMVs related to Availability Groups in SQL Server 2019 CU9
Does anyone know what the purpose of the new DMVs is?
It's really around as cached data so that the DMV can be hit often without incurring certain performance hits (think orchestration operations and ...
5
votes
Cluster Resource fails every 8 hours for SQL AG
One thing I have noticed is that the Windows Cluster Name is the same as the AG name and I wonder if there is a conflict.
There is no issue there. If there were, it wouldn't come online in the first ...
3
votes
Accepted
What affects log_send_rate in Normal or Distributed AG other than OS resources?
Thanks a lot @sqL_handLe and @Josh Darnell for your comments on this.
But actual cause in this particular issue was byte sector size missmatch on source (512) and destination (4096).
While checking ...
- 125
4
votes
What affects log_send_rate in Normal or Distributed AG other than OS resources?
Some additional factors to consider for low SQL Server Availbility Group log send rate.
This article gives good description and troubleshooting steps for a number of conditions that can result in ...
- 1,413
6
votes
What affects log_send_rate in Normal or Distributed AG other than OS resources?
A great resource for digging into this is Sean Gallardy's post: Network Throughput Hysteria
The first thing would be to make sure that you are comparing equivalent things. From the post:
I almost ...
- 27.4k
0
votes
What is causing this error: None of the specified replicas for availability group ag1 maps to the instance of SQL Server to which you are connected
Actually, the N'name' should be same as the value from 'select @@servername'. if you modify computer name then you shoud keep the instance server name same as it.
- 1
7
votes
Accepted
How does an async AG secondary sync itself with the primary when secondary missed tlog record due to a power failure on secondary server?
When the secondary starts up, then how does it sync its database with the primary?
I'm making broad strokes here because the minutia isn't important, the overall process, however, is the main point ...
3
votes
Accepted
Whether the disconnected state caused by session timeout is to be manually or automatically resolved?
Once the session timeout has expired, and it goes into a disconnected state, when next does it try to re-establish a connection and whether this is automatic or manual?
It's automatic and it happens ...
2
votes
upgrade OS and SQL Server version on SQL Cluster
The best way, with the least downtime, would be to build new servers and install the latest version of SQL. This is true for several reasons.
Rollback If anything goes wrong, you can simply revert ...
- 3,219
3
votes
What does FCI owners in a WSFC mean and how does it prevent adding replica to same WSFC?
Think of Availability Groups and FCIs at different levels.
An Availability group is a standalone instance of SQL Server. Each node is a unique instance of SQL Server and is live.
FCI is a single ...
- 3,219
2
votes
Accepted
Does the SQL AG based corruption resolution work for a enterprise edition read scale AG and for basic AG?
SQL provides 2 kinds of AG architecture.
I wouldn't call those architectures, I know this wasn't your question, but it needed to be pointed out.
Does the SQL AG based corruption resolution work for ...
3
votes
Accepted
Can I use SQL AG to create readable secondary when primary is enterprise and secondary is standard edition?
Does enterprise edition primary and standard edition secondary support readable secondary
No. Standard Edition can only use Basic AGs, and EE can't use Basic AGs. So you can't have any sort of AG ...
- 40.6k
4
votes
Can you create AlwaysOn in Azure (primary) with a readable secondary replica on premises?
SQL Server on Azure VMs is just regular SQL Server. So yes, this is possible. In fact it's not any different from having the primary on-prem and the secondary in Azure. Once you set it up you can ...
- 40.6k
Top 50 recent answers are included