SOLVED

Azure Services for Fundraising & Engagement

Copper Contributor

@chriszimney & team - We are implementing the Microsoft Cloud for Nonprofit at a client and would like to understand the following further: 

  1. What guidance exists for helping procure the right size SQL database for payment processing? 
  2. What other paid Azure resources are required to complete the deployment processing? Understanding the total cost of ownership is important. 
  3. What is the expected/typical monthly cost in Azure Services based on ~17 Sales Enterprise Users & ~15 Power App Users & assuming the Dynamics environments are not pay-as-you-go? 

Thank you!

3 Replies
best response confirmed by alex_kasavin_msft (Microsoft)
Solution

Hello @Chelsea_Henkel,

Here are our answers to the questions:

 

What guidance exists for helping procure the right size SQL database for payment processing?
The appropriate SQL database size will depend on data volumes, particularly the number of Contacts and Transactions. As a general rule of thumb, I would recommend starting with the lowest possible tier and scaling up as necessary. For instance, for a database containing approximately 10K contacts and 1M transactions, the Premium P1 tier with 125 DTUs and 500 GBytes is advisable.

What other paid Azure resources are required to complete the deployment processing? Understanding the total cost of ownership is important.

The most expensive service will be Azure SQL, which is responsible for over 80% of the total cost. Other services include a few Azure Data Factory pipelines and Azure Functions, both of which have relatively marginal costs.

What is the expected/typical monthly cost in Azure Services based on ~17 Sales Enterprise Users & ~15 Power App Users & assuming the Dynamics environments are not pay-as-you-go?


As mentioned earlier, the cost will depend on the number of Contacts and Transactions. However, in the scenario I outlined, the expected cost would be less than US$ 200/month in the worst-case scenario.

Thanks for the patience.

Gustavo Muller

@g_muller81 Thank you for the detail. Is the estimate cost per environment or would this include sandbox & production instances?

Hello @Chelsea_Henkel, sorry, I missed your follow-up question.
These estimates would be per environment.

1 best response

Accepted Solutions
best response confirmed by alex_kasavin_msft (Microsoft)
Solution

Hello @Chelsea_Henkel,

Here are our answers to the questions:

 

What guidance exists for helping procure the right size SQL database for payment processing?
The appropriate SQL database size will depend on data volumes, particularly the number of Contacts and Transactions. As a general rule of thumb, I would recommend starting with the lowest possible tier and scaling up as necessary. For instance, for a database containing approximately 10K contacts and 1M transactions, the Premium P1 tier with 125 DTUs and 500 GBytes is advisable.

What other paid Azure resources are required to complete the deployment processing? Understanding the total cost of ownership is important.

The most expensive service will be Azure SQL, which is responsible for over 80% of the total cost. Other services include a few Azure Data Factory pipelines and Azure Functions, both of which have relatively marginal costs.

What is the expected/typical monthly cost in Azure Services based on ~17 Sales Enterprise Users & ~15 Power App Users & assuming the Dynamics environments are not pay-as-you-go?


As mentioned earlier, the cost will depend on the number of Contacts and Transactions. However, in the scenario I outlined, the expected cost would be less than US$ 200/month in the worst-case scenario.

Thanks for the patience.

Gustavo Muller

View solution in original post