SQL Azure Database - Temporary Increase DTU Service Tier for database benchmark

Question

Hello,

We want to temporarily increase DTU Service Tier for Azure SQL Database for 2 hours. The purpose is to make a benchmark of our database in sense of performance.
For example, we would make a switch from Standard S0 (10 DTUs) to Standard S4 (200 DTUs) service tier model.
Our question is: How this short switch would reflect on the costs ?

If anyone knows I would ask you to share your experiences.

Thanks in advance.

Answer 1

Those 2 hours, instead of cost you 4 cents (dollar currency based on East US) using S0 tier, they will cost you 80 cents. Aproximately 76 cents will be the impact on the monthly billing.

Take in conisderation that when you scale up/down to a service tier in the middle of an hour, you will pay the whole hour as the higher of the service tiers involved on the scale process. For example, if you are scaling from S0 to S4, the whole hour will be billed as S4 even when half of the hour the database was using S0.

For more information, see the Azure SQL pricing page.