I am facing related to out of memory. I have asked detailed question below here in this post
Please provide your opinion for best suited App service plan for Function APP.
I am running a .net webjob on azure app service in production environment. This webjob reads .json file from azure blob and store into sql database. Some of my the files includes data up to 2 GB.
I am getting out of memory exceptions in azure appservice, however it worked absolutely fine in development machine.
I would like to try couple of options from azure side.
Converting webjob to Azure function which will autoscale as per requirement.
Currently I am using Premium v2 P3V2. Below is the picture of app service plan

Uttam ChaturvediPosted Oct 30, 2024, 11:35 AM
I have been facing similar issue recently and posted it on stackoverflow with my reply. I hope it would help you, please accept answer if you find it useful
https://stackoverflow.com/questions/78006482/troubleshoot-azure-appservice-out-of-memory-exception-with-huge-data/78153370#78153370
Jayraj ChhayaPosted Feb 19, 2024, 7:48 AM
To address the out of memory exceptions in your Azure App Service, consider the following options:
Optimize Memory Usage: Review your code for memory leaks or inefficient memory management practices. Ensure that resources are released properly after processing large files.
App Service Plan: Evaluate the App Service Plan for your Function App. For handling large files and memory-intensive tasks, consider a higher-tier plan with more memory allocation. You may need to scale up to a higher tier to accommodate the memory requirements of processing 2 GB files.
Azure Functions: Convert your web job to an Azure Function. Azure Functions offer autoscaling capabilities, which can dynamically adjust resources based on workload demands. This can help manage memory usage more efficiently.
By optimizing memory usage, selecting an appropriate App Service Plan, and considering Azure Functions for scalability, you can mitigate out of memory exceptions and enhance the performance of your application in the Azure environment.