How to choose services?

KANISH S 0 Reputation points
2023-07-21T07:17:51.3633333+00:00

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?

Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
3,991 questions
Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,699 questions
Azure Batch
Azure Batch
An Azure service that provides cloud-scale job scheduling and compute management.
293 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Tech-Hyd-1989 5,776 Reputation points
    2023-07-21T08:23:07.05+00:00

    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.

    0 comments No comments

  2. AllenXu-MSFT 14,511 Reputation points Microsoft Vendor
    2023-07-24T01:53:14.9566667+00:00

    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.