New answers tagged

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 ...
user avatar
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-...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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.
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar

Top 50 recent answers are included