When you are working on the AlwaysOn feature, it is crucial to understand how the AlwaysOn commit process works. This blog will walk you through how a synchronous and Asynchronous commit process works in AlwaysOn. Data Synchronization in Synchronous mode  Primary replica is generating transaction log blocks. The secondary replica establishes a valid connection to […]

Recently, I was working on the AlwaysOn Availability group issue where the log records were not moving from primary to secondary replica because of the wait type “PARALLEL_REDO_TRAN_TURN”. During the troubleshooting, when I opened the AlwaysOn Dashboard to see the Log Send Rate, I found that the Log Send Rate was coming blank against the […]

When you configure SQL Server AlwaysOn Availability Group from management studio, it may fail with below error while joining secondary replica to the availability group. Today, While I was preparing some demo on AlwaysOn for the community event, I encountered the same issue. So, I thought to blog the solution here so that it can […]

When a database is part of AlwaysOn Availability Group, it means whatever commands we are executing on Primary replica database, those commons will also be sent to all the Secondary replicas database via log records. So, If you are adding a database file – data or log to the Primary Replica, the add file command will […]

In the SQL Server AlwaysOn setup, whenever you are using a listener to connect to a secondary node, you have to provide additional connection parameters like ApplicationIntent=ReadOnly so that you can connect the secondary node. If you have to connect many times in a day to the secondary node, keying the additional connection parameters becomes […]

The AlwaysOn_health XEvent session is installed by SQL Server by default, and started by the Create Availability Group wizard when a new availability group is created. AlwaysOn_health Extended Event Session The xEvent session collects events triggered by events directly affecting AlwaysOn availability group like; AlwaysOn errors AlwaysOn state transitions AlwaysOn DDL executed to create, drop, […]

The AlwaysOn Dashboard is an excellent tool in SQL Server Management Studio that allows you to monitor Replica status, Availability Group status, and Database status. But, if you are wondering what the Dashboard uses internally to monitor the AlwaysOn health, so here is the answer – It utilizes system policies for monitoring AlwaysOn health. Policy […]

If you are working on SQL Server Availability Group Databases, you may have seen that Availability Group is online but at-least one availability database at the primary or the secondary is not synchronizing. In the blog, we are going to explore how to find what has interrupted synchronization between availability databases on the primary and a […]