skills.rest
tombelial666
tombelial666COMMUNITY
Explore all skills by this author →
GitHub

load-smoke-jmeter-sqlserver

Automate SQL Server load smoke tests with JMeter and generate markdown delta summaries.

Updated Mar 24, 2026
Search Tags:#regression#jmeter#load-testing#sql-server#qa-automation#performance-metrics#non-prod
One-click install
npx skills add https://github.com/tombelial666/test --skill load-smoke-jmeter-sqlserver
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: load-smoke-jmeter-sqlserver
Source: https://github.com/tombelial666/test/tree/main/.cursor/skills/load-smoke-jmeter-sqlserver
Command: npx skills add https://github.com/tombelial666/test --skill load-smoke-jmeter-sqlserver

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Automates non-prod load smoke tests against SQL Server using JMeter and captures before/after snapshots of performance counters and waits, and generates a markdown delta summary for quick regression triage.

Core Features & Use Cases

  • Quick, repeatable load smoke tests in non-prod environments against a SQL Server.
  • Capture before/after performance counters and wait times to enable delta analysis.
  • Produce a markdown delta summary to support rapid regression triage.
  • Orchestrates the run via a PowerShell script (tasks/run_db_metrics_228370.ps1) and collects evidence files.

Quick Start

Run the included PowerShell task with your desired baseline and load durations.

Frequently Asked Questions about load-smoke-jmeter-sqlserver

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I run a JMeter load smoke test against a SQL Server database?▼

You can automate a JMeter load smoke test against SQL Server by providing a JMeter test plan and setting environment variables like SQL_USER and SQL_PASS, then executing the included PowerShell script to capture metrics.

What is a load smoke test with database evidence and when do I need it?▼

A load smoke test with database evidence captures before and after SQL Server performance counters and wait times. You need it for rapid regression triage in non-prod environments to quickly identify performance degradations.

Can I capture SQL Server performance metrics before and after a JMeter run?▼

Yes, you can capture SQL Server performance counters and wait times before and after a JMeter run. The Skill automates this snapshot collection and generates a markdown delta summary for quick regression analysis.

What environment variables do I need to set up for SQL Server load testing with JMeter?▼

For SQL Server load testing with JMeter, you must set SQL_USER, SQL_PASS, ET_APP_KEY, VALID_USERNAME, and WRONG_PASSWORD. Optional variables include SQL_SERVER, SQL_DATABASE, and SQL_PORT for connection configuration.

Does this load testing approach work for production environments?▼

No, this load testing approach is designed specifically for non-prod environments. It applies to quick, repeatable load smoke scenarios to enable rapid triage of regressions without impacting production database performance.

Why use a PowerShell script for JMeter database metrics collection?▼

Using the PowerShell script tasks/run_db_metrics_228370.ps1 orchestrates the JMeter run and collects before and after database evidence files. This ensures consistent snapshot capture for generating accurate regression delta summaries.

Related Skills

Explore More Software Engineering Skills→
vignesh2027vignesh2027
6

load-tester

Design and execute standardized load tests for APIs and applications.

Community
Advanced
luicabref97luicabref97

git:load-issues

Fetches all open GitHub issues and saves them as markdown files.

Community
Intermediate
zerAdazerAda

bmad-qa-generate-e2e-tests

Generate end-to-end API and UI tests for identified application features.

Community
Advanced
pacphipacphi
6

performance-testing

Plan and execute load, stress, spike, endurance, and scalability tests.

Community
Advanced