Infrastructure at your Service

High availability Archives - Page 3 of 7 - Blog dbi services

David Barbarin

Migrating your existing availability group infrastructure to 2016

By | Database Administration & Monitoring | No Comments

Have you already a plan to migrate your old SQL Server 2012 availability group infrastructure to windows 2016 and SQL Server 2016? In a previous post, I talked about distributed availability groups and cross-cluster migration scenarios but this time the game is not the same because we want to achieve an in-place upgrade of the existing AG infrastructure. This question will probably be a concern the next year and if we take a closer look…

 
Read More
David Barbarin

SQL Server 2016: distributed availability groups and cascaded replicas

By | Database Administration & Monitoring | No Comments

During the last MVP summit, we had some interesting discussions about availability groups with the SQL Server team and I remember someone asked for managing scenarios like Oracle cascaded destinations and the good news is that SQL Server 2016 already addresses this kind of scenario with distributed availability groups. For example, let’s say you have to manage heavily reporting activity on your application and a solution would be to offload this activity across several secondary…

 
Read More
David Barbarin

SQL Server AlwaysOn availability groups and statistic issues on secondaries

By | Database Administration & Monitoring | 3 Comments

I would like to share with you an interesting issue you may face while using SQL Server AlwaysOn availability groups and secondary read-only replicas. For those who use secondary read-only replicas as reporting servers, keep reading this blog post because it is about update statistics behavior on the secondary replicas and as you may know cardinality estimation accuracy is an important part of the queries performance in this case. So a couple of days ago,…

 
Read More
David Barbarin

SQL Server 2016: Distributed availability groups and Cross Cluster migration

By | Database Administration & Monitoring | 2 Comments

How to migrate an environment that includes availability groups from one Windows Failover Cluster to another one? This scenario is definitely uncommon and requires a good preparation. How to achieve this task depends mainly of your context. Indeed, we may use a plenty of scenarios according to the architecture in-place as well as the customer constraints in terms of maximum downtime allowed for example. Among all possible scenarios, there is a process called “cross-cluster migration…

 
Read More
David Barbarin

SQLSaturday #546 Porto – Troubleshooting scenarios with availability groups

By | Database management, Technology Survey | No Comments

J-1 before the next SQL Saturday 2016 in Portugal. I usually promote this event in France but this time this is for SQL Server Portuguese community. I will have the chance to talk about SQL Server AlwaysOn and troubleshooting scenarios. It will be also a good opportunity to meet portuguese people like Niko Neugebauer (@NikoNeugebauer), André Batista (@klunkySQL) and many others. Moreover, Porto is definitely a beautiful city and a good way to finish the summer…

 
Read More
David Barbarin

SQL Server AlwaysOn: troubleshooting improvements with new service packs

By | Database Administration & Monitoring | No Comments

As promised in my latest blog, I will talk about improvements in the detection of the availability group replication latency. As a reminder, replication latency between high available replicas may be monitored in different manners so far. Firstly, in my experience I had the opportunity to use different performance counters as “Database Replica:Transaction Delay” and “Databas Replica:Mirrored Write Transactions/sec” in order to get a good picture of the latency over the time after implementing an…

 
Read More
David Barbarin

SQL Server 2016 AlwaysOn: distributed availability groups

By | Database Administration & Monitoring | No Comments

This time, I will talk about distributed availability groups. What’s that? In short, a group of availability groups. Sounds good right? But in which cases may we need such architecture? Firstly, let’s say that distributed availability groups will run on the top of two distinct availability groups meaning that they reside on two distinct WSFCs with their own quorum and voting management. Referring to the Microsoft documentation here, we may think that this new feature…

 
Read More
David Barbarin

SQL Server AlwaysOn: is my database ready for failover?

By | Database Administration & Monitoring | No Comments

In this blog post I just want to clarify values that we may find from the is_failover_ready column of the sys.dm_hadr_database_replica_cluster_states DMV. A couple of days ago, I had an interesting discussion with one of my customers during which he explained he was not confident about the availability group state after facing some unavailability issues. The main source of uncertainty was the result from the following query that he used to check if everything was…

 
Read More
David Barbarin

Windows Failover Cluster : Introduction to paxos tag

By | Database Administration & Monitoring, Operation systems | No Comments

A couple of days ago, I was in charge to install a new SQL Server AlwaysOn and availability group with one of my colleague Nathan Courtine. During the installation, we talked about testing a disaster recovery scenario where we have to restart the Windows Failover cluster in forced quorum mode. Restarting a WSFC in such mode implies some internal stuff especially for the cluster database data synchronization between nodes. The WSFC uses internally the paxos…

 
Read More
David Barbarin

Windows Server 2016: Introducing stretch cluster functionality

By | Database Administration & Monitoring, Hardware & Storage | One Comment

Let’s continue with the new high available functionality shipped with the next Windows version. In my previous blog, I talked about the new site awareness feature that provides more flexibility to configure failover resources priorities and more granular heartbeat threshold as well by introducing the new site concept. This time, we’ll talk about stretch cluster. What’s that? Let’s introduce the concept with some customer experiences for which we introduced high availability with the implementation of…

 
Read More