Skip to main content

SQL Query Stress

Stress test and optimize your SQL Server queries with multi-threaded performance analysis

Key Features

Multi-threaded Testing

Run concurrent queries with configurable threads and iterations to simulate real-world load

Cross-Platform CLI

Use sqlstresscmd on Windows, Linux, and macOS with consistent results

Performance Metrics

Track CPU time, I/O stats, logical reads, and elapsed time in real-time

Query Parameterization

Data-driven testing with dynamic parameter values from database queries

Quick Start

1

Install the tool

Choose between the Windows GUI application or cross-platform CLI tool
# Download from GitHub Releases
# https://github.com/ErikEJ/SqlQueryStress/releases
2

Configure your test

Set up your connection string, query, and load parameters
sqlstresscmd -x
# Creates sample.json configuration file
3

Run stress test

Execute your load test and analyze results
sqlstresscmd -s sample.json -t 1

Use Cases

Query Optimization

Test query performance before and after index changes

Load Testing

Simulate production load to identify bottlenecks

Capacity Planning

Determine maximum concurrent users your system can handle

Explore the Documentation

Installation Guide

Get SQL Query Stress installed on your system

Using the GUI

Learn to use the Windows desktop application

CLI Reference

Complete command-line options and flags

Configuration

Detailed settings and connection options

Build docs developers (and LLMs) love