SQL Server Workgroup Cluster FCM Errors

Background One of the new features of SQL Server 2016 is the ability to use SQL Server with Failover Cluster in a workgroup rather than joined to Active Directory. When working with SQL Server and Failover Clustering in a workgroup, many of the abilities that are normally used with Active Directory are no longer available,…

0

Azure RM: Configure a second Availability Group with a Listener using the External Load Balancer

In a previous post, we have reviewed Azure RM: How to create SQL Server AlwaysOn Availability Groups Listener configuration with Azure External Load Balancer, this is the second part of the delivery, have fun. In Azure Resource Manager a Load balancer can include one or more front end Public IP addresses, otherwise known as a…


Azure RM: SQL Server AlwaysOn Availability Groups Listener configuration with Azure External Load Balancer

I want to thank to Ruben Gonzalez for his guidance.   This blog post explains how to configure SQL Server AlwaysOn AG with an External Listener in Azure VMs running in Resource Manager model. Pre-requisites Before to start ensures that the environment is ready, deploy VMs in Azure RM model: Create a Resource Group. Create a Virtual…


Monitoring SQL Server 2012 AlwaysOn Availability Groups Worker Thread Consumption

In most cases, people utilize SQL Server features and capabilities in a common and typical usage pattern.  But there are some instances where environments do something just a little different, or fill the bucket to the absolute brim.  With the advent of AlwaysOn Availability Groups, it is such a robust high availability and disaster recovery…


Flow Control in Always On Availability Groups – what does it mean and how do I monitor it?

A question was posed to me whether Flow Control which existed in Mirroring was still relevant for Availability groups. Flow Control is primarily a mechanism to gate or throttle messages to avoid use of excessive resource on the primary or secondary. When we are in “Flow Control” mode, sending of log block messages from the…


SQL 2012 AlwaysOn Availability groups Automatic Failover doesn’t occur or does it – A look at the logs

  I was dealing with an issue where we had an AlwaysOn availability group with 2 replicas configured for Automatic failover. There was a 30 second glitch where folks could not connect to the Database on the primary and automatic failover did not kick in. Well, that was our initial impression at least. The purpose…