BE SHARING

AlwaysOn

Automate CNOs and VCOs for SQL Server AAG

26.02.2021 by Nathan Courtine

During the installation of a new SQL Server environment in a Project, we wanted to automate the whole process deployment and configuration when installing a new SQL Server Always On Availability Group (AAG). This installation requires to prestage cluster(…)

Database Administration & Monitoring

SQL Server AlwaysOn node “Add all eligible storage to the cluster”

14.10.2020 by Steven Naudet

I made a mistake recently when adding a new node to an existing Windows Failover Cluster supporting AlwaysOn SQL Server instances. When adding a new node using the GUI there’s this option checked by default named “Add all eligible storage(…)

Database Administration & Monitoring

SQL Server – Collecting last backup information in an AlwaysOn environment

12.12.2019 by Christophe Cosme

Introduction Sometimes you face interesting challenges with unusual environment. One of my customer needed a automated and flexible backup solution. Said like that nothing very complex you will say. But if I mention that some databases were 60TB big with(…)

Database Administration & Monitoring

SQL Server 2017 AlwaysOn AGs and new read-scale architectures

21.04.2017 by Microsoft Team

As you probably know Microsoft announced an official name for SQL Server vNext during the last Microsoft Data Amp event on April 19 2017. It becomes officially SQL Serve 2017. In my first(…)

Database Administration & Monitoring

SQL Server AlwaysOn – Distributed availability groups, read-only with round-robin capabilities

08.02.2017 by Microsoft Team

This blog post comes from a very interesting discussion with one of my friends about the read-only capabilities of secondary replicas in the context of distributed availability groups. Initially, distributed availability groups are designed to address(…)

Database Administration & Monitoring

SQL Server 2016: Distributed availability groups and Cross Cluster migration

24.10.2016 by Microsoft Team

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(…)

Database Administration & Monitoring

SQL Server 2016 : Basic availability groups may fit to your HA needs

16.09.2016 by Microsoft Team

In this blog let’s talk about SQL Server and availability groups in standard Edition. I had some customer questions about existing limitations and this is a good opportunity to review them on this blog post. First of(…)

Database Administration & Monitoring

SQL Server AlwaysOn: troubleshooting improvements with new service packs

02.08.2016 by Microsoft Team

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(…)

Database Administration & Monitoring

SQL Server AlwaysOn: new services packs and new diagnostic capabilities

18.07.2016 by Microsoft Team

As you certainly know, the SQL Server 2014 SP2 has been released by Microsoft with some interesting improvements that concern SQL Server AlwaysOn and availability groups feature.

Database Administration & Monitoring

SQL Server 2016 AlwaysOn: Direct seeding and backup considerations

12.07.2016 by Microsoft Team

As promised in my prior blog post, we’ll talk now about direct seeding feature and backups. We found an interesting LIMIT_CONCURRENT_BACKUPS value for current state of the hadr_automatic_seeding_state_transition event. As said last time, this value is(…)