Tags » Always On

Windows 2016 Failover Cluster Services now has load balancing (enabled by default)

Having a production system with “new technology” is always keen to give you some issues you didn’t know about earlier on.

Lately, due to the arrival of BizTalk Server 2016 and related support for Windows Server 2016 and SQL Server 2016, we’ve seen some things we did calculate for. 170 more words

BizTalk Server

Help: SQL Server Always On Availability Group Listener not working in Azure SQL VMs (Using Internal Load Balancer - ILB). How to troubleshoot?

As many of you might know that currently I have been supporting SQL Server in Azure Virtual Machines. Most of the concepts remains same but one of the common issue which was reported by many customer is about Always On listener connectivity. 507 more words

AlwaysOn

Sobre la Alta Disponibilidad en SQL Server

SQL Server 2014 incluye varias opciones para la implementación de alta disponibilidad. Estos incluyen el trasvase de registros, lo que refleja la base de datos y grupos de disponibilidad AlwaysOn para proteger las bases de datos, así como las instancias de clúster de conmutación por error de AlwaysOn, una tecnología que se basa en Windows Server Failover Clustering (WSFC), para proteger las instancias de SQL Server. 784 more words

Administración SQL

Note-To-Self: ICYMI, #MIM2016 Support for SQL Always On Availability groups

Based on a recent customer support experience with MIM (migrating from MIM 2016 RTM to SP1 latest hotfix), I ran into a few issues…

They have been documented here: 187 more words

Note-to-self

Removal of IP Fastpath in ONTAP 9.2

ONTAP 9.3 is already GA as of December, but there was a pretty significant change to how networking operates in ONTAP 9.2. However, this change impacts any release after 9.1, so it’s good to bring up. 836 more words

Tech

sp_AGReconfigure 1.1 is now available

sp_AGReconfigure 1.1 is now available HERE and on GitHub

V1.1 includes a new Parameter and some minor bug fixes:

@Readable

NULL – DEFAULT:  Ignore Readable secondary check (acts as though you are using V1) 302 more words

Database Administration

Creating a SQL Server Test Lab On Your Workstation – Part Three, Creating a Windows Failover Cluster and a SQL Server Availability Group

Welcome along to the third part of our series ‘Creating a SQL Server Test Lab On Your Workstation’.  If you’ve followed along with the first two parts, you should have a domain setup and a SQL Server joined to it.  1,670 more words

Database Administration