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.

Part 1

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/

Part 2

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/

Part 3

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

✅Check PART 4 for here 👉 https://mostafaelmasry.com/2020/09/10/troubleshooting-performance-issues-like-microsoft-engineers-part-4/

Keep Following

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.