How to choose services?

Question

Hey, Could you please tell me that, which is more suitable azure service to handle the heavy load of the excel calculation with efficiency and without termination of any requests?

Answer 1

Hello KANISH S

Sure, here are two Azure services that are suitable for handling heavy load Excel calculations:

• Azure Functions. Azure Functions are serverless compute services that allow you to run code without provisioning or managing servers. This makes them a good choice for handling large numbers of concurrent requests, as you only pay for the resources that you use. Azure Functions can be used to execute Excel calculations, and they can be scaled up or down as needed to meet the demands of your application.
• Azure Batch. Azure Batch is a service that allows you to run large-scale batch jobs. This makes it a good choice for handling complex Excel calculations that require a lot of processing power. Azure Batch can be used to run Excel calculations on a cluster of virtual machines, and it can scale up or down as needed to meet the demands of your application.

Here is a table that summarizes the key features of Azure Functions and Azure Batch:

Scalability	Scales up or down automatically	Scales up or down manually
Cost	Pay for the resources that you use	Pay for the number of jobs that you run
Programming languages	Supported by all languages that run on .NET Core	Supported by .NET Core, Java, Python, and R
Ease of use	Easy to get started with	More complex to set up

Ultimately, the best Azure service for handling heavy load Excel calculations will depend on your specific requirements. If you need a scalable and cost-effective solution, then Azure Functions is a good choice. If you need a more powerful solution that can handle complex Excel calculations, then Azure Batch is a good choice.

I hope this helps! Let me know if you have any other questions.

Answer 2

Hi @KANISH S,

When selecting an Azure service for handling heavy load of Excel calculations, there are several criteria to consider. Based on the information you've provided, it seems that you need a batch processing service that can handle large amounts of data and execute long-running tasks without termination, but it's unclear whether you want to manage the servers yourself or use a managed service. Here are some key questions to help narrow down your options:

• Do you want a managed service rather than managing your own servers?
• Do you want to author batch processing logic declaratively or imperatively?
• Will you perform batch processing in bursts? If yes, consider options that let you auto-terminate the cluster or whose pricing model is per batch job.
• Do you need to query relational data stores along with your batch processing, for example, to look up reference data? If yes, consider the options that enable the querying of external relational stores.

Based on your specific needs, some potential options include Azure Batch, Azure Functions, or Azure Logic Apps. Azure Batch provides a managed service for large-scale parallel and high-performance computing (HPC) batch jobs that can process large amounts of data. Azure Functions is a serverless compute service that enables you to run event-triggered code without managing the infrastructure. Azure Logic Apps can automate workflows across different systems and services, and can integrate with Excel online and offline services to perform calculations and analysis.

Microsoft provides a range of resources to help you choose the right service for your needs, including detailed documentation and decision criteria for choosing different services. I recommend reviewing these resources to determine the best fit for your use case.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.