IF you are a Database administrator and managing SQL Server Database so this article for you, this article is a parent for 3 parts for How to troubleshoot the performance issues on SQL Servers such as Microsoft engineers and support team.
In the first part, I explained the built tools and reports in SQL Server and some other scripts free you can use it for troubleshooting performance issues.
✅Check the first part for here 👉 https://mostafaelmasry.com/2020/09/09/troubleshooting-performance-issues-like-Microsoft-engineers-part-1/
In the second part, I explained How we can collect all of the SQL Server logs during the performance issues using the PSSDIAG tool.
✅Check the second part for here 👉 https://mostafaelmasry.com/2020/09/09/troubleshooting-performance-issue-like-Microsoft-engineers-part-2/
In the third part, I explained How we can load and analyze the output of the PSSDIAG tool using the SQL Nexus tool and Performance Analysis of Logs (PAL) tool.
✅Check the third part for here 👉 https://mostafaelmasry.com/2020/09/09/troubleshooting-performance-issues-like-Microsoft-engineers-part-3/
In this part we will talk about Some of the cases that can lead us for AG latency