cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

SQL Server Support Blog
Options
21.6K

What is causing the Always On AG issue? Is it cluster, AD, DNS, or SQL?

Dharshana on Apr 23 2023 02:29 PM
AG (Always On Availability Groups) is a logical container that holds one or more user databases that failover together. ...
21.3K

​​​Let's make it easy! How to read System Health and sp_server_diagnostics?​

JuanPabloSalg on Mar 29 2023 08:11 AM
Here are some useful steps on how to read System Health and SP_Server_Diagnostic with condition that will trigger warnin...
1,944

Applying SQL Server 2017 CU18 on secondary replica running on Linux OS may fail with script failure

JayaprakashJothiraman on Dec 19 2019 04:31 PM
If SQL Server 2017 is running on Linux operating system and if you have databases configured using Always ON feature, po...
2,314

Create a monitoring and notification mechanism for HADR worker thread Pool

Joseph_Pilov on Feb 10 2019 05:23 PM
First published on MSDN on Dec 07, 2017 A customer approached us asking for help on automatic a monitoring process.
7,480

What really happens when HADR_CLUSAPI_CALL wait type is set?

Joseph_Pilov on Feb 10 2019 05:23 PM
First published on MSDN on Aug 18, 2017 In a customer scenario we saw a query against system views related to AlwaysOn t...
1,984

DBMIRROR_DBM_MUTEX: The world of Redo Operations

Joseph_Pilov on Feb 10 2019 05:23 PM
First published on MSDN on May 26, 2017 There are times when you just run into something and you can deem less important...
16.3K

DbMgrPartnerCommitPolicy::SetSyncState May Seem More Mysterious than It Actually Is

Joseph_Pilov on Feb 10 2019 05:22 PM
First published on MSDN on May 24, 2017 AlwaysOn has become a major SQL Server technology.
9,054

AGLatency report tool V2.2 introduction

Simon Su on Jan 15 2019 06:04 PM
First published on MSDN on Sep 08, 2018 I wrote an article to discuss about data movement latency between AG groups:http...
6,189

Lesson learned from an Availability Group performance case

Simon Su on Jan 15 2019 06:00 PM
First published on MSDN on Apr 05, 2018 Writer: Simon SuTechnical Reviewer: Pam Lahoud, Sourabh Agarwal, Tejas Shah Prob...
34.3K

Troubleshooting data movement latency between synchronous-commit AlwaysOn Availability Groups

Simon Su on Jan 15 2019 05:57 PM
First published on MSDN on Apr 05, 2018 Writer: Simon SuTechnical Reviewer: Pam Lahoud, Sourabh Agarwal, Tejas ShahAppli...
2,820

Analyze Synchronous Commit Impact on High Commit Rate Workloads

mssql-support on Jan 15 2019 05:50 PM
First published on MSDN on Feb 06, 2018 Workloads that rely on auto-commit (each operation like an INSERT has an implied...
5,435

Analyze Network Latency Impact on Remote Availability Group Replica

mssql-support on Jan 15 2019 05:45 PM
First published on MSDN on Dec 21, 2017 Multisite availability groups allow customers to deploy copies of business data ...
113K

Availability Group Database Reports Not Synchronizing / Recovery Pending After Database Log File Inaccessible

mssql-support on Jan 15 2019 05:41 PM
First published on MSDN on Nov 29, 2017 You may find that one or more availability group databases is reported ‘Not Sync...
1,420

Avoid Availability Group Database Data Loss: Do not Deploy File Share Witness From DFS Namespace

mssql-support on Jan 15 2019 05:34 PM
First published on MSDN on Aug 29, 2017 Cluster Quorum File Share Witness Should Not be Part of a DFS NamespaceWhen depl...
12.5K

SQL Server : Large RAM and DB Checkpointing

Guillaume Fourrat on Jan 15 2019 05:32 PM
First published on MSDN on Jun 29, 2017 SQL Server : large RAM and DB Checkpointing Hi everyone,This post’s purpose is t...
4,547

Troubleshooting Internal Load Balancer Listener Connectivity in Azure

mssql-support on Jan 15 2019 05:25 PM
First published on MSDN on Feb 22, 2017 Problem Unable to Connect to Azure availability group listener Creating an avail...
3,674

How to Apply Transaction Logs to Secondary When it is Far Behind

mssql-support on Jan 15 2019 05:24 PM
First published on MSDN on Feb 22, 2017 Problem Large Send Queue You discover that the log send queue for a given availa...
2,479

Making Service Broker Application Highly Available With AlwaysOn

mssql-support on Jan 15 2019 05:23 PM
First published on MSDN on Jan 26, 2017 If you have a Service Broker (SSB) application connecting to SQL Server using an...
2,131

Unable to connect to SQL Server AlwaysOn Listener on Azure due to misconfigured subnet mask

mssql-support on Jan 15 2019 05:20 PM
First published on MSDN on Dec 04, 2016 When it comes to troubleshooting, the more you know the better troubleshooter yo...
1,023

AlwaysOn Readable Secondaries Can Display Misleading Data & Log File Paths

mssql-support on Jan 15 2019 05:09 PM
First published on MSDN on Jun 29, 2016 Written By:Grant Carter, Senior Premier Field EngineerReviewed By:Mark Weber – P...
648

SQL 2016 - It Just Runs Faster - AlwaysOn AES-NI Encryption

mssql-support on Jan 15 2019 05:05 PM
First published on MSDN on May 05, 2016 The SQL Server 2016, AlwaysOn, log transport takes advantage of hardware based e...

Latest Comments

ReinisBerzins
in Effectively troubleshoot latency in SQL Server Transactional replication: Part 1 on Aug 30 2024 12:42 PM
Thanks for the information. Some of the screenshots are too small to be readable unfortunately. Text is very helpful though.
1 Likes
Arslanov
in Effectively troubleshoot latency in SQL Server Transactional replication: Part 2 on Jul 17 2024 06:32 AM
Part 1: Effectively troubleshoot latency in SQL Server Transactional replication: Part 1 - Microsoft Community Hub
0 Likes
Arslanov
in Effectively troubleshoot latency in SQL Server Transactional replication: Part 1 on Jul 17 2024 06:31 AM
Part 2: Effectively troubleshoot latency in SQL Server Transactional replication: Part 2 - Microsoft Community Hub
0 Likes
Arslanov
in Effectively troubleshoot latency in SQL Server Transactional replication: Part 2 on Jul 16 2024 10:44 PM
Video version in Youtube: https://youtu.be/Xl7Irfxkajk?si=a4l_qvdURlbdbWV4
1 Likes
Arslanov
in Effectively troubleshoot latency in SQL Server Transactional replication: Part 1 on Jul 16 2024 08:30 PM
Video version in Youtube: https://youtu.be/tQ5SdB-_Rkg 
1 Likes