Skip to content

SQL Workload Generator v2.0.0

v2.0.0

LatestNov 16, 2026

New 🎉

  • Dark mode: the app follows the Windows light/dark setting, including the code editors, syntax highlighting, charts and output windows.
  • Localization: the UI is translated through NTDLS.Localization. Choose Tools > Language... to switch languages at once, and the choice is remembered. A Localization.bat is included to update the translations.
  • $RampDownDelay setting: threads now stop one at a time (last started first). The default of 0 stops them all at once.
  • Immediate stop: close the run window a second time (or press a key a second time in the console app) to skip the ramp down and cancel running commands.
  • Peak time and run windows can now run past midnight, such as 10PM to 6AM.
  • Help > Example Project opens the sample project folder.
  • 76 new snippets, organized into folders: People and Places, Dates and Times, Numbers and Identifiers, Variables, Database Lookups, Statements and Workload Headers.
  • User guide (USER_GUIDE.md) covering the UI, settings inheritance, functions, variables, asset files with ::DS() and running from the console.
  • .vwgp file association, per user and without admin rights.

Changed 😎

  • Moved to .NET 10, with the solution converted to .slnx and all dependencies updated.
  • Redesigned UI, with the forms reorganized and using NTDLS.WinFormsHelpers theming.
  • The installer now installs for the current user without admin rights, and installs no other registry settings.
  • Settings are now inherited through every folder level, from Workloads down to the script, with the closest one winning.
  • The first thread now starts immediately on ramp up, and $RampUpDelay is applied between threads.
  • ::Int(min, max) now includes the maximum.
  • Trailing -- comments and indented settings are accepted on setting lines.
  • The console app stops gracefully on a key press or Ctrl+C, and exits with a code if the project can't be loaded.
  • Drag and drop from the functions explorer now drags text.

Fixed 🐛

  • Script variables (::Set / ::Get) were shared by all threads of a workload, so threads overwrote each other's values. Each thread now has its own.
  • Several identical functions in one statement (::Int(1, 5) ::Int(1, 5)) all received the same value.
  • Data sample text containing $1 or $& was altered.
  • ::DS() could never return the last line of an asset, and blank lines in assets could be returned.
  • ::Decimal produced a comma decimal separator under some regional settings.
  • ::Left, ::Right and ::SubString threw on short text.
  • T-SQL such as geography::Point(...) was mistaken for a function.
  • A line containing only ::Set left a blank line behind in the SQL.
  • Stopping during ramp up could start more threads afterwards, and the stop waited out the ramp-up sleep.
  • A workload with a configuration error crashed the app instead of being skipped.
  • A failing server was retried in a tight loop. Retries now wait at least a second.
  • Rows were counted once per result set instead of once per row, and the record delay was applied once per result set.
  • The reported statement duration was overwritten instead of accumulated.
  • Statistics could be corrupted when updated from several threads at once.
  • Random numbers could break under heavy multithreaded use, because one random generator was shared by all threads.
  • A missing Assets folder or a duplicate asset name caused an error when loading a project.
  • The $Mode and $IntegratedSecurity templates in the function's explorer lacked their colon.
An unhandled error has occurred. Reload 🗙