SqlQueryStress
azure-sql-hyperscale-autoscaler
| SqlQueryStress | azure-sql-hyperscale-autoscaler | |
|---|---|---|
| 3 | 1 | |
| 887 | 15 | |
| - | - | |
| 5.8 | 2.4 | |
| about 2 months ago | 6 months ago | |
| C# | C# | |
| MIT License | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
SqlQueryStress
-
Security logs for splunk dataset
Sample Log Generator: This tool generates synthetic logs that you can customize to fit your needs. While not real-world data, it can be useful for testing specific scenarios or queries: https://github.com/ErikEJ/SqlQueryStress
-
Over thinking update with rowlock
You could try SqlQueryStress to mock out your database interaction and then increase the threads to see how it handles and then use SP_WhoIsActive to see what you are waiting on while that test is running.
-
Autoscaling Azure SQL Hyperscale
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.
azure-sql-hyperscale-autoscaler
-
Autoscaling Azure SQL Hyperscale
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.
What are some alternatives?
SqlClient - Microsoft.Data.SqlClient provides database connectivity to SQL Server for .NET applications.
azure-functions-core-tools - Command line tools for Azure Functions
SqlKata Query Builder - SQL query builder, written in c#, helps you build complex queries easily, supports SqlServer, MySql, PostgreSql, Oracle, Sqlite and Firebird
azure-sql-db-openai - Samples on how to use Azure SQL database with Azure OpenAI
monitor-table-change-with-sqltabledependency - Get SQL Server notification on record table change
dbt-synapse - dbt adapter for Azure Synapse Dedicated SQL Pools
DayZCommunityOfflineMode - A community made offline mod for DayZ Standalone
azure-functions-host - The host/runtime that powers Azure Functions
fluentmigrator - Fluent migrations framework for .NET [Moved to: https://github.com/fluentmigrator/fluentmigrator]
azure-sql-db-change-stream-debezium - SQL Server Change Stream sample using Debezium
botsv4
azure-saas - The Azure SaaS Development Kit (ASDK) provides a reference architecture, deployable reference implementation and tools to help developers, startups, ISVs and Enterprises deliver their applications as a SaaS service. A platform for platform creators.