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

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