This is part of a series on setting up SQL Server availability groups on Linux. It details how to enable High Availability Disaster Recovery (HADR) on SQL Server, including creating master keys, certificates, and availability groups. Clear instructions are provided for configuring SQL Server and Pacemaker to ensure data redundancy and high availability. Follow these steps to enhance the reliability of your SQL Server instances on Ubuntu 20.04.
Category: SQL Server 2022
Creating SQL Server AGs on Linux: Part 1 – Installing and Configuring Pacemaker
This post is the first part of a series on setting up SQL Server availability groups on Linux. It covers the installation and configuration of Pacemaker on Ubuntu 20.04, creating the Pacemaker cluster, and configuring essential cluster properties. Designed for SQL Server DBAs with limited Linux experience, this guide lays the foundation for a robust high availability environment.
SQL Server on Linux: Getting Started with SQL Server 2022 on Red Hat 9
Learn how to install and configure SQL Server 2022 on Red Hat Enterprise Linux (RHEL) 9. This guide provides step-by-step instructions for adding the Microsoft repository, installing SQL Server and its tools, and performing basic configurations to optimize SQL Server for enterprise environments on RHEL 9.
Navigating the Changes in SQL Server 2022: A Guide to Server Alias Configuration
If you’re embarking on a fresh installation of SQL Server 2022, you might be in for a surprise. Gone are the familiar days of the SQL Server Native Client being a core component of SQL Server installations. This blog post will discuss the recent changes in SQL Server 2022 and how to navigate server alias configuration in this new landscape.
Understanding Availability Group Synchronization in SQL Server
A fundamental aspect of managing Availability Groups is understanding how data synchronization occurs between the primary and secondary replicas within the group. This process ensures that all replicas are up-to-date, reflecting changes made in the primary database across all secondary databases in the group. Let’s look into how this synchronization works and the importance of the ‘redo’ operation in maintaining data consistency.
System Level Performance Tuning for SQL Server 2022 on Linux
Running SQL Server on Linux offers many advantages, including cost savings and robust management tools. To fully realize these benefits, certain Linux-specific configurations must be tuned. This post focuses on three specific areas: I/O scheduler, swapfiles, and swappiness. So let’s jump in and start tinkering!
Flow Control in Availability Groups and SQL Server 2022 Enhancements
SQL Server’s flow control in Availability Groups ensures optimal resource usage by managing log message distribution, thus safeguarding system performance. This mechanism operates seamlessly without compromising replica synchronization, with monitoring options available for detailed analysis. The latest iteration in SQL Server 2022 further refines flow control, enhancing the database’s efficiency and stability.
Optimizing SQL Server with the Tuple Mover and Columnstore Indexes
SQL Server’s performance and efficiency hinge on its ability to manage and store data effectively. At the heart of this capability are Columnstore Indexes and the Tuple Mover, a duo that works together to ensure data is stored efficiently, making it readily accessible for fast query execution. This post takes a look into the interplay between Columnstore Indexes and the Tuple Mover, highlighting the operational details and the impact of recent enhancements introduced in SQL Server 2019.
Enhancing Data Durability with SQL Server’s REQUIRED SYNCHRONIZED SECONDARIES TO COMMIT Feature
SQL Server 2017 marked a significant advancement in high availability architectures by introducing the REQUIRED_SYNCHRONIZED_SECONDARIES_TO_COMMIT setting. This feature enhances data protection and integrity within Availability Groups (AGs) by meticulously controlling the transaction commit process across replicas. Its role has continued to be pivotal in subsequent releases, including SQL Server 2022, showcasing Microsoft’s commitment to robust data protection mechanisms.
SQL Server’s Query Optimizer: Bridging the Gap to Peak Performance
We are always in search of ways to optimize query performance. At the heart of achieving these goals within SQL Server is the Query Optimizer, a sophisticated component of the SQL Server Database Engine. Its primary role is to evaluate various potential execution plans for a given query and select the most efficient path forward. This process is necessary for minimizing resource consumption and execution time, while enhancing the overall performance and scalability of database operations.