Our great sponsors
-
SqlQueryStress
SQL query stress simulator created by Adam Machanic http://dataeducation.com/sqlquerystress-the-source-code/
-
SqlClient
Microsoft.Data.SqlClient provides database connectivity to SQL Server for .NET applications.
-
InfluxDB
Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
To simulate a simple workload, you can use powerful load testing tools like Locust, K6 or Apache JMeter where you can simulate even the most complex and realistic workload. To create a simple workload, a nice tool originally written by Adam Machanic is also available: SQL Query Stress.
Autoscaling a service is a challenging job, especially if the workload is not easy predictable. But thanks to Azure SQL Hyperscale elasticity and quick scalability this can be done using an Azure Function, with minimal service interruption, especially if following the best practices and implementing correct connection retry logic. Remember also to use the latest .NET driver as they already implement some reconnection logic that in several common cases will make the reconnection completely transparent.
Sample source code is available here. If you want to contribute, by adding some of the improvements described below, please feel free to do so. I'll be more than happy to accept contributions to this repo.