SQL Server High Availability (HA) Solutions
1. 数据库镜像（Database Mirroring） 原理： 数据库镜像技术通过维护两个数据库副本（一个主副本和一个镜像副本）来提供高可用性。在数据库镜像中，主数据库会将其事务日志发送到镜像数据库，并实时应用。镜像模式可以是同步模式（保证数据一致性）或异步模式（提高性能但可能导致数据丢失）。 …
标签文章Posts
10 篇posts
Azure Arc-Enbaled SQL Server Instance With AKS
Azure data controller Setup https://docs.microsoft.com/en-us/azure/azure-arc/data/create-data-controller-direct-cli?tabs=windows create resources gro…
Sql Server Best Practice
CPU最佳实践。 根据CPU架构和核数配置MaxDop. https://learn.microsoft.com/zh-CN/sql/database-engine/configure-windows/configure-the-max-degree-of-parallelism-server-c…
SQL Server AG With Docker Without Pacemaker
概览 Prepare the Dockerfile with HA feather Build image with Dockerfile just created Create the SQL server nodes with the image which with HA feather C…
CSS-Sql Server Troubleshooting Tools
Connection https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/connect/resolve-connectivity-errors-overview https://github.com/microso…
Register Sql Server to Azure Arc
概览 Microsoft official document: https://learn.microsoft.com/en-us/sql/sql-server/azure-arc/connect?view=sql-server-ver16&tabs=azure%2Cwindows Bef…
How to Find Blocking and Deadlock in SQL Server
视频教程 What is deadlock in SQL Server? What is Blocking in SQL Server? What is difference between deadlock and blocking in SQL Server? How to create de…