Blog Post

Azure Database Support Blog
3 MIN READ

Lesson Learned #342: Slow communication between our applications and Azure SQL

Jose_Manuel_Jurado's avatar
Mar 30, 2023

We used to have service requests that our customers reported slow communications between their applications and db servers. Following I would like to share with you several details to detect where might be the issue that is causing this issue.

 

The first thing that we need to review 3 things:

 

 

 

 

Once we have how much is the latency about the connection and we followed the best practices, for example, using for, example, accelerated networking in Virtual Machine that your application is running Lesson Learned #223:Hands-On-Labs: How to improve a bulk insert process - Microsoft Community Hub the next step is to understand if the latency is executing the queries, for example, SQL Server Profiler in Azure Data Studio plugin to review the execution of every one. 

 

Finally, once we checked all these details, the next step is to review the wait stats, we have many articles about it:

 

 

We are continuosly working on other lessons learned about slow communication between our applications and db servers.

 

Enjoy!

Updated Mar 30, 2023
Version 4.0
No CommentsBe the first to comment