Planning Azure SQL Server I've been tasked to prepare Azure SQL database deployment plan and I am struggling with it...

I've been given following information:


2 million transactions will arrive to database daily throughout the day (~278 tr/sec on average).
Transactions will arrive from 1000 different locations (onprem SQL Servers generating 2000 transactions daily each)
All transactions will have a fixed size of 12KB. Therefore I am expecting to get about about 22-23 GB of data daily.
All data will be regularly aggregated and accessed from 100 different locations for BI purposes.
Updated data (configurations) will be sent back to aforementioned 1000 locations


I've tried to use Azure SQL DTU calculator, but it requires to run PowerShell script on existing server and I don't have one... This a new system, that is currently in development and it is planned to run on Azure SQL.

I also tried to find the way to convert transactions to DTU or Vcore, but failed to find any.

Can anyone please help me with that? Or point me in to right direction to choose correct plan to suffice my needs based on info provided.

Thank you in advance.
Mike
Easy!
Use the Azure SQL Database DTU Calculator:

Download the PowerShell script on your server
Run powershell -ExecutionPolicy Bypass -File .\sql-perfmon.ps1 and let it run for a few minutes
On the web page enter the number of cores that your server is using
Stop the PowerShell script and upload the .CSV file that is now on the C:\ root