Forum Discussion
Azure Services for Fundraising & Engagement
chriszimney & team - We are implementing the Microsoft Cloud for Nonprofit at a client and would like to understand the following further:
- What guidance exists for helping procure the right size SQL database for payment processing?
- What other paid Azure resources are required to complete the deployment processing? Understanding the total cost of ownership is important.
- 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!
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_muller81Microsoft
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 Mullerg_muller81 Thank you for the detail. Is the estimate cost per environment or would this include sandbox & production instances?
- g_muller81
Hello Chelsea_Henkel, sorry, I missed your follow-up question.
These estimates would be per environment.
