Technology Performance Pulse

data-synchronization-in-sql-server-always-on-availability-groups

Data synchronization in SQL Server Always On Availability Groups

SQL Shack

MAY 3, 2019

This article describes the data synchronization process on SQL Server Always On Availability Groups in both Synchronous, and Asynchronous data commit mode. High data availability is an important aspect of every DBA’s life.

Availability

Availability Servers Database Processing

Suspend and Resume Data Movement in SQL Server Always On Availability Groups

SQL Shack

SEPTEMBER 23, 2020

In this 26th article for SQL Server Always On Availability Groups series, we will discuss the process to suspend and resume data movements between AG replicas.

Availability

Availability Servers Network Processing

Join 5,000+

Insiders

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

Dynatrace

Isolation levels behavior in SQL Server Always On Availability Groups

SQL Shack

JUNE 18, 2019

In my previous article, Data synchronization in SQL Server Always On Availability Groups, we explored the internal data synchronization for both Asynchronous and Synchronous data commit mode.

Availability

Availability Servers Processing

Proof of Concept: Horizontal Write Scaling for MySQL With Kubernetes Operator

Percona

MAY 15, 2023

The scaling, in that case, is offered by the different number of Replica nodes, no matter if using standard asynchronous replication or synchronous replication. The main reason behind this is that MySQL is a relational database system (RDBMS), and any data that is going to be written in it must respect the RDBMS rules.

Traffic

Traffic Scalability Database Servers

Automatic Seeding in Always On Availability Groups

SQL Shack

JUNE 18, 2019

Introduction In SQL Server Always On Availability Groups, we can add a database into an existing availability group using different methods. We get the following option in the Initial Data Synchronization wizard in SSMS. It […].

Availability

Availability Database Servers

SQL Server Always On Availability Group Data Resynchronization

SQL Shack

MAY 9, 2019

In my previous article Data Synchronization in SQL Server Always On Availability Group, we described a scenario where if a secondary replica goes down in synchronous data commit mode, SQL Server Always on Availability group changes to asynchronous data commit mode.

Availability

Availability Servers

SQL Server On Linux: Forced Unit Access (Fua) Internals

SQL Server According to Bob

DECEMBER 18, 2018

SQL Server relies on Forced-Unit-Access (Fua) I/O subsystem capabilities to provide data durability, detailed in the following documents: SQL Server 2000 I/O Basic and SQL Server I/O Basics, Chapter 2. Be sure to deploy SQL Server 2017 CU6 or newer for best data durability and performance results. “.

Servers

Servers Media Cache Storage

Understanding Execution Plan Operator Timings

SQL Performance

MARCH 8, 2021

SQL Server 2014 SP2 and later produce runtime (“actual”) execution plans that can include elapsed time and CPU usage for each execution plan operator (see KB3170113 and this blog post by Pedro Lopes). Interpreting these numbers is not always as straightforward as one might expect. Compatibility level 150 is used exclusively.

Servers

Servers Tuning Architecture Processing

How Parallel Plans Start Up – Part 2

SQL Performance

APRIL 8, 2021

This is the second part of a five-part series taking a deep dive into the way SQL Server row mode parallel plans start up. SQL Server executes a query through a process known as a query scan. The query processor continues calling GetRow on the root node until no more rows are available. Iterative Execution.

Storage

Storage Transportation Engineering Processing

Aurora vs RDS: How to Choose the Right AWS Database Solution

Percona

JULY 1, 2023

Now that Database-as-a-service (DBaaS) is in high demand, there are multiple questions regarding AWS services that cannot always be answered easily: When should I use Aurora and when should I use RDS MySQL ? These may be performance, high availability, operational cost, management, capacity planning, scalability, security, monitoring, etc.

AWS

AWS Database Serverless Storage

SQL Server 2016 – It Just Runs Faster: Always On Availability Groups Turbocharged

SQL Server According to Bob

SEPTEMBER 26, 2016

When we released Always On Availability Groups in SQL Server 2012 as a new and powerful way to achieve high availability, hardware environments included NUMA machines with low-end multi-core processors and SATA and SAN drives for storage (some SSDs). Now disk I/O and CPU capacity were no longer an issue.

Availability

Availability Servers Hardware Benchmarking

SQL Server I/O Basics Chapter #1

SQL Server According to Bob

JANUARY 11, 2020

Microsoft SQL Server I/O Basics Author: Bob Dorr, Microsoft SQL Server Escalation Published: December, 2004 SUMMARY: Learn the I/O requirements for Microsoft SQL Server database file operations. © 2004 Microsoft Corporation.

Servers

Servers Cache Media Hardware

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

JANUARY 11, 2020

Copyright The information that is contained in this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication. This White Paper is for informational purposes only. Complying with all applicable copyright laws is the responsibility of the user.

Servers

Servers Cache Database Media

Data synchronization in SQL Server Always On Availability Groups

Suspend and Resume Data Movement in SQL Server Always On Availability Groups

Trending Sources

Isolation levels behavior in SQL Server Always On Availability Groups

Proof of Concept: Horizontal Write Scaling for MySQL With Kubernetes Operator

Automatic Seeding in Always On Availability Groups

SQL Server Always On Availability Group Data Resynchronization

SQL Server On Linux: Forced Unit Access (Fua) Internals

Understanding Execution Plan Operator Timings

How Parallel Plans Start Up – Part 2

Aurora vs RDS: How to Choose the Right AWS Database Solution

SQL Server 2016 – It Just Runs Faster: Always On Availability Groups Turbocharged

SQL Server I/O Basics Chapter #1

SQL Server I/O Basics Chapter #2

Stay Connected