SQL Workload Generator

Table of Contents

Overview
All Topics
Related

The Vroom SQL Workload Generator is a unique tool that allows users to easily generate widely varied yet realistic workloads against a SQL Server for the purposes of performance tuning, profiling, data-set generation, see more...

For more information check out the getting started guide.

All Topics
A C D E G I L M O P R S T U W

Advanced Configuration - Working with configuration macros to manage and vary a workload.
Application (Configuration) - The name of the application that will be reported to SQL server.

CommandDelay (Configuration) - The number of milliseconds to sleep between SQL statements, per thread.
CommandTimeout (Configuration) - The number of seconds for each command timeout.

Database (Configuration) - The name of the database to set the database context.
DataSample - Use the DataSample function to retrieve random samples of data from asset files.
Date - Returns a date by default (optionally also a time) depending on a specified date/time format.
Date and Time Formats - Standard date and time format strings.
Double - Generates a random decimal number inside of a specified range.
DS - Use the DataSample function to retrieve random samples of data from asset files.

EndTime (Configuration) - The end time of the day that the script will be run.

Get - Retrieves the value of a previously set variable.
Getting Started Guide - Setting up and running a a new SQL Workload Generator project
GUID - Generates a globally unique identifier, GUID or UID.

Int - Generates a random whole integer number inside of a specified range.
IntegratedSecurity (Configuration) - Defined the type of authentication to use when connecting to SQL Server.

Left - Extracts a specified number of characters from a string (starting from left).
Length - Returns the number of characters in a string, or the total length of a given object.

MachineName - Returns the name of the machine running the workload generator process.
Mode (Configuration) - The type of workload to execute.

Overview - A general overview of the Vroom SQL Workload Generator.

PadLeft - Pads a string them with spaces (or a specified character) on the left, for a given total length.
PadRight - Pads a string them with spaces (or a specified character) on the right, for a given total length.
Password (Configuration) - The user password to use for the login to SQL server.
PeakRunDays (Configuration) - The days of the week that will be considered for peak-time workload multiplication.
PeakTimeBegin (Configuration) - The time of the day at which the standard load will begin to be increased.
PeakTimeEnd (Configuration) - The time of the day at which the $PeakTimeMultiplier will be disregarded.
PeakTimeMultiplier (Configuration) - The percentage of $CommandDelay that will be subtracted as peak time approaches.

RampUpDelay (Configuration) - The number of milliseconds to sleep between each thread creation when starting up.
RandomString - Generates a random string of a specified length, optionally using a given set of limiting characters.
RecordDelay (Configuration) - The number of milliseconds to sleep between each row retrieval, per thread.
Right - Extracts a specified number of characters from a string (starting from right).
RunDays (Configuration) - The days of the week that the workload will be run.

Server (Configuration) - The name of the server to connect to.
Set - Sets a variable so that it can be retrieved and reused later in a workload or script.
SHA1 - Computes a standard cryptographic SHA1 hash for a given string.
SHA256 - Computes a standard cryptographic SHA256 hash for a given string.
Sleep - Causes the current executing thread to sleep (or pause) for a specified duration.
SQL - Executes a scalar SQL statement and returns the value to the generator for use in script generation.
SQL Workload Generator - SQL Workload Generator - Product
StartTime (Configuration) - The start time of the day that the script will be run.
SubString - Extract a portion of a string that begins at a specified position and has a specified length.

Threads (Configuration) - The number of threads for the workload script.
TickCount - Retrieves the number of milliseconds that the operating system has been operating. The system uptime.
Time - Returns a time by default (optionally also a date) depending on a specified date/time format.
TitleCase - Returns the title case (aka Proper Case) of a given string.
ToLower - Converts the given string to all lowercase.
ToUpper - Converts the given string to all uppercase.

URLDecode - Reverses the encoding provided from a previous call to URLEncode .
URLEncode - Generates a safe-for-url variant of a given string.
UserName - Returns the operating system level username that is executing the workload.
UserName (Configuration) - The user name to use for the login to SQL server.

Working with Assets and functions - Working with asset sample files and functions to generate truly random workloads.
Write - Writes text to the output tab of the workload generator.

Date and Time Formats - Standard date and time format strings.