Product Home
DTM DB Stress Online Documentation Prev Page Prev Page
General Information
Product Profile
Product Versions
Execution Modes
Task Properties
General Properties
Task Options
Parameters
Task Connection
Task Scripts
Group of tasks
Execution Console
Execution Reports
Data Generator
Project Properties
Connect to Database
Quick Start
Direct Connection
Connect to Desktop File
Data Sources
DSN File
OLE DB Connection
Connection Profile
Connection Information
Troubleshooting Guide
Statistics
Settings
Diagram
Log Viewer
Hot Keys
Advanced Options
Dynamic Statements
Command Line
Performance Counters
Show Execution Plan
SQL Library
Report Comparison
Version Controls
SQL console
Report Visualizer
Additional Information
Installation
Uninstall
License
Demo and Full versions
Technical support
How to order
Upgrade
Trademark Information
Database utilities

General Task Properties

This dialog box helps you to set general task properties. The most important properties are:

  1. Task name - displayed in the task list in the main program window.
  2. Number of iterations to be performed before the task is executed. Important: this option works with "by task property" execution mode only.
  3. Number of concurrent threads the program should create for a task of this type.
  4. Text of the SQL statement representing the content of the task - it is exactly what will be executed within this task. You should switch on "Use SQL parser" option in case you want to use complex script (set of SQL statements). "go" or ";" statements separators are recommended. There are two ways to specify SQL script: immediately entering or external file reference.

Also, this dialog box allows you to load an SQL statement from a file on the disk (the "Load" button), from SQL Library and to test if the current statement is correct (the "Test" button).

The stress tool allows you to select one of three ways to use the file with data. In the first case, all task threads use the file with data independently. It means that they open the file on their own and sequentially process records in it. In the second case, each thread uses only one set of values (a string with data) from the file. In this case, the number of strings in the file with data must coincide with the number of threads launched for the task. The third way is when all threads read from the file sequentially.

DTM DB Stress: General task properties Dialog Screenshot

Note: the user can specify default values for most important task properties at Settings window.