I want to know how many requests (read/write) per second the azure SQL server can handle and what is the cost if I have 1000 request per second I am using Standard S0: 10 DTUs
I want to know how many requests (read/write) per second the azure SQL server can handle and what is the cost if I have 1000 request per second I am using Standard S0: 10 DTUs
For S0 Max requests (concurrent workers) is 60 as explained here. To support 1,000 or more you need S7. S7 has a limit of 1,600 requests.
S7 cost you $1.6130/hour on EastUS, please use this URL to calculate based on the Azure region of your preference.
Some more information for you about S7, it allows a minimum of 6 cores or 12 cores depending on hardware generation, 19,200 maximum number of sessions, maximum worker threads 2,675.
Thank you @AlbertoMorillo
@ayhamnasser-0983 - Please let us know if you need any further help.
8 people are following this question.