App Service keeps crashing/unresponsive (have large database)

Jason D'Orazio 0 Reputation points
2023-02-07T21:51:38.0233333+00:00

I created an Azure app service which is associated with a database with one 2.5G table. The app service never successfully loads; it always crashes or is unresponsive. Could it be because of the large database? I have the "Azure Database for MySQL, Flexible Server Burstable BS Series" plan.

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
713 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
6,879 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. SnehaAgrawal-MSFT 18,361 Reputation points
    2023-02-14T08:47:07.98+00:00

    Thanks for reaching here! It's possible that the large database table is causing the app service to crash or become unresponsive. The "Azure Database for MySQL, Flexible Server Burstable BS Series" plan is designed for small to medium workloads, so it may not have enough resources to handle a large table.

    Also you can check this by enabling crash monitoring:

    To access Crash Monitoring, browse to your App Service in the Azure Portal and click Diagnose and Solve problems in the left navigation panel. Then, click on the home page tile named Diagnostic Tools. Once you are inside Diagnostic Tools, click Crash Monitoring.

    Screenshot 2023-02-09 170906

    Further you can also Run a load test to identify performance bottlenecks in a web app

    Let us know if further query or issue on this.