SqlQueryStress is a simple, lightweight tool designed to help you benchmark SQL Server databases and execute large quantities of SQL queries in a controlled manner.

NOV 5, 2024

Features

• Concurrency Control: Execute multiple concurrent queries to simulate high load scenarios.
• Configurable Iterations: Decide how many times the query should be run.
• Customizable Load Parameters: Input parameters for the SQL queries can be customized.
• Performance Metrics: Get details about CPU time, total elapsed time, and other important metrics for every executed query.

Installation

1. Download the latest release from the official Github repository.
2. Unzip the downloaded package.
3. Run SqlQueryStress.exe.

Usage

1. Database: Connect to a database by clicking on the 'Database' button and filling in the required details.

2. Query Input: Enter your SQL query in the provided text box.

3. Parameters Substitution(Optional): Adjust the number of iterations and threads according to the desired stress test intensity.

4. GO: Click the 'Start' button to begin the test.

5. Results: Once the test is complete, performance metrics will be displayed in the result panel.