SQLQueryStress

Background

Performance Issues & Load Stressing Exercises are never faraway ideas from a DBA thoughts.

Let us try out SQLQueryStress.

 

SQLQueryStress

Lineage

SQLQueryStress born out of work by Adam Machanic.

Now maintained by Erik Ejlskov Jensen ( ErikEJ ).

 

Artifacts

The source code for SQLQueryStress is available from ErikEJ’s GitHub site.

Here is the URL :-

ErikEJ/SqlQueryStress
Link

Download

Please download the source code from the GitHub site:

download_20180820_1107PM

Build

Please launch Visual Studio.

The community edition V2017 is the one that I have.

Access the Source Code’s solution file and  build the solution.

 

Deliverable

Once built we will access the bin\Debug for the executable ( SQLQueryStress.exe )

build_debug_20180820_1114PM

 

Usage

Outline

  1. Please click the Database button to enter Database specification details
    • Server
    • Authentication
      • Integrated Authentication
      • SQL Server Authentication
    • Database
  2. Load Details
    • Number of Iterations
    • Number of Threads

Database

database_20180820_1120PM

Entry

Load Settings

entry_20180821_1232AM

SQL Query

SQLQueryStress_Usage_Perform_20180821_0836AM

Execute Test

Please press GO to execute the test.

 

Review Results

SQLQueryStress_Query0N_Completed_Exceptions_20180821_0907PM.PNG

One thought on “SQLQueryStress

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s