Cluster Quorum PowerShell Commands

Here are some Cluster PowerShell Commands worth having in your arsenal. Get-Cluster This will simply show the cluster name Get-ClusterQuorum | ft QuorumType This will confirm the Quorum type in use. For an AlwaysOn configuration, this should be node majority. For a Failover Cluster Instance then this should be node Continue Reading

Configure Quorum for SQL Server High Availability

Quorum, quorum, quorum, quorum, quorum. Quorum, quorum, quorum, quorum, quorum, quorum and quorum. Quorum, quorum, quorum! Quorum, quorum, quorum, quorum, quorum, quorum, quorum. Quorum, quorum, quorum, quorum, quorum, quorum; quorum, quorum, quorum. If you repeat the word quorum enough times, you will eventually learn and understand it. If only that Continue Reading

Availability Groups: 5 Things

Here are some configurations that I feel are worth noting about AlwaysOn Availability Groups.  There are plenty of other best practices and configuration guides around but these are issues I’ve experienced when supporting existing AlwaysOn AGs and have therefore re-configured them or added these configurations to my standard AG builds. Continue Reading

Index Maintenance and Availability Groups

I have a very large database which I migrated to a virtual server and then implemented AlwaysON availability groups. It’s a 3 node cluster with one Primary (obviously), a Synchronous read-only secondary and an asynchronous non-readable node in a DR data centre. One thing that was very noticeable after the Continue Reading

SQL Agent and AlwaysON Availability Groups

So we all know that SQL Agent isn’t part of an availability group and therefore (like logins, operators, alerts, linked servers etc) your SQL jobs won’t sync. But even when they are synced, I’m sure there are plenty that should only run on the Primary Node and therefore shouldn’t run Continue Reading

Restoring Secondary Nodes in an AlwaysON Availability Group

There have been a few scenarios where I have had to create a fresh backup of a database and restore the secondary nodes in an Availability Group. Normally the route cause has been when a secondary node has stopped syncing due to hardware failure, excessive log growth, low bandwidth or Continue Reading