question

CorbinBethurem-2869 avatar image
0 Votes"
CorbinBethurem-2869 asked ryanchill answered

How do I know if SQL is causing an issue with my application performance?

I have an Azure Web App that has been performing quite slow lately. My code has a few dependencies, and I am thinking that one of these such as SQL may be the cause for performance degradation. Is there any way from the Web App that I can confirm if one of these dependencies may be causing the issue?

azure-webappsazure-webapps-performance
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ryanchill avatar image
1 Vote"
ryanchill answered

If you have an application experiencing slow performance, one way to approach scoping this would be to use the Diagnose and solve problems blade in Portal (pictured below).

82513-image.png

Here we can type into the search box “Web App Slow” which will list out your Top 5 Slowest Dependency Executions. When SQL may be an issue, the name field will have the word “database” within it.

82458-image.png


Once this is seen, we can navigate to the SQL database and start looking at areas such as resource consumption (CPU, Memory), as well as seeing if we can optimize queries.


More verbose logging options such as Memory Dumps or .NET Profiler Traces which can be collected through Auto-Heal rules / manually can also lead to narrowing the issue down to SQL. These can be configured by navigating again to Diagnose and solve Problems -> Diagnostic Tools.

82475-image.png

However, the initial recommendation of using the “Web App Slow” detector would be the quickest way to scope the issue, only using verbose logging as needed.




image.png (73.5 KiB)
image.png (7.3 KiB)
image.png (51.0 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.