Infrastructure at your Service

Tag

High availability Archives - Page 5 of 9 - Blog dbi services

Microsoft Team

Dealing with WSFC 2016 quarantine state and availability groups

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

I was playing with my lab environment which includes Windows 2016 and SQL Server 2016 and I noticed an interesting scenario while testing cluster node failures. After simulating some network outage scenarios, I was not able to bring back my cluster node online immediately by using traditional way. A quick look at the cluster manager led me to notice something new: A quarantined state value … interesting! But what does it mean exactly? In respect…

Read More
Microsoft Team

MS Cloud Summit Paris 2017

By | Database management | No Comments

Une nouvelle annĂ©e commence et 2017 devrait ĂŞtre un bon cru dans le domaine de la base donnĂ©e notamment en prĂ©diction des effets d’annonces faites par Microsoft cette fin d’annĂ©e 2016. En effet, il a Ă©tĂ© notamment Ă©tĂ© question de la prochaine vNext de SQL Server qui sera portĂ© sous Linux ainsi que des nouvelles fonctionnalitĂ©s prometteuses. A l’habitude, l’Ă©quipe dbi services tentera couvrir les diffĂ©rents sujets au cours cette annĂ©e. N’hĂ©sitez pas Ă  revenir de temps en temps…

Read More
Microsoft Team

Migrating your existing availability group infrastructure to 2016

By | Database Administration & Monitoring | 10 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
Microsoft Team

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
Microsoft Team

SQL Server AlwaysOn availability groups and statistic issues on secondaries

By | Database Administration & Monitoring | 9 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
Microsoft Team

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
Microsoft Team

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
Microsoft Team

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
Microsoft Team

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
Microsoft Team

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