Blog Archives

Alwayson Availability Group Replica is Not Synchronizing (Error: 976, Severity: 14, State: 1.)

For some reason you can lose communication between the primary and secondary replicas. As known, there is a policy on SQL Server to check the data synchronization state of the database replica. The policy is in an unhealthy state when the

Tagged with: , ,
Posted in AlwaysOn, High Availability, Issues

How to monitor Timeout and Changes Roles from Availability Groups with Alerts

Agent alert can send alerts by email when occur some action/timeout between databases in your Availability Group Environment. It allows you to become proactive. The following script shows how to create these alerts. You can also configure to execute another

Tagged with: , , , , ,
Posted in Administration, Alerts, AlwaysOn, Scripts

How to validate Quorum Vote from Windows server Failover Cluster (AlwaysOn)

If you have configured a Windows server Failover Cluster with more than two Nodes, you must care about the “votes” in each Node. Let’s imagine the following environment: You have two Nodes configured in Automatic Failover/Synchronous mode with AlwaysOn Availability

Tagged with: , , ,
Posted in Administration, AlwaysOn, Cluster, High Availability

How to Monitor AlwaysON – Primary / Secondary Replicas on SQL Server

Last month I developed a procedure to run in a SQL Server Agent Job, to monitor the synchronism status of the AlwaysOn Availability Groups. In case of “NO HEALTHY” status, the SP will send an email providing details of every

Tagged with: , , ,
Posted in Alerts, AlwaysOn, Scripts, Security

Availability Groups Setup and Configuration from A to Z

AlwaysOn Availability Groups was introduced in SQL Server 2012, and it’s one of the most important features in the history of SQL Server. The link provided below, as far as I’m concerned, it’s a complete step by step on how

Tagged with: , ,
Posted in Administration, AlwaysOn, High Availability