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
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
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
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
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
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
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
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
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
2 votes
Accepted

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
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

Only top scored, non community-wiki answers of a minimum length are eligible