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