Transaction Generator 0.84 is a Database Management product from trgn.la.coocan.jp, get 5 Stars SoftSea Rating, TG ( Transaction Generator ) is a simple load testing tool for commercial and free relational databases ( Example : ORACLE and MySQL, etc ).

Unlike other common load testing tools which send HTTP requests to the target application, TG generates SQL based transactions. Specifically, TG simulates a heavy load on the target database server with multiple virtual clients sending SQL statements at random which are specified manually.

TG enables various verification tests concerning the database system which include 1) testing the performance, 2) detecting the bottleneck in the database, 3) tuning the application, and other useful features.

TG simulates multiple users accessing the database simulatenously using the Java THREAD function. Incidentally, at TG we call THREAD "Agent". Each agent connects to the database and execute transactions in a random order according to the ratio which is previously specified.

TG generates a load with sending a series of SQL statements on the target database server which is registered as a transaction.

You can register multiple transactions on TG and set an execution-ratio to each transactions.
TG choose a transaction according to these execution-ratio.

And, You can use random variables into SQL statements which construct a transaction. For example, TG can access various data every time it execute transactions with random variable at the "WHERE" statement.

You can choose two types of interface to control TG. 1) interactive command-line interface and 2) GUI based interface which is called TGC( TG Controller ). Using TGC, you can configure transactions and control agents more easily.

TGC and TG communicate with each other via the network. Therefore you can run both TG and TGC in different nodes at the same time. This is impactful for arranging TG in a high performance server and controlling it from TGC which is running on a PC.

At the moment, TGC is only available on windows platform. The license of this business & finance software is Freeware, you can free download and free use this Business & Finance software.