SQL Server

SQL Server Distributed Availability Group (DAG) is a special type of AG that sits on top of existing Availability Groups configured on On-Premise SQL Server instances or Azure VM’s or AWS EC2. DAG enables cross-region, cross-cloud, cross datacenter DR for SQL Server databases. Also, this helps in the ease of migrations of large-scale SQL Server Databases to desired cloud platforms with minimal cutover window and downtime. In this document, we will learn how we can migrate from SQL Server on Azure/AWS or OnPrim to Tessell SQL Server HA using a Distributed Availability Group.

This guide provides a detailed walkthrough of the procedures to establish a high-availability (HA) configuration for Microsoft SQL Server, guaranteeing database robustness and minimizing downtime during failures or maintenance operations.

In this article, we conduct performance benchmarks to assess, analyze, and compare the performance of SQL Server database engines running on Azure - Tessell and Azure Managed Instance for SQL Server. We utilized the HammerDB benchmarking tool for the benchmarking process to make a repeatable, verifiable comparison.