Database Reference
In-Depth Information
The following steps are required in implementing benchmarking a framework on multiple
instances of the data platform:
1.
the TPC-C relevant benchmarking reports
.
2.
In addition to TPC-C-related reports, the tool can be used to perform testing a new
database platform for throughput.
3.
The command-line arguments for this tool are:
Commands are in \x:option format.
No spaces between the \x: and the option specified.
Valid command line arguements are:
\c:{1} number of clients you wish to run max 200
\s:{servername} name of the database server to benchmark
\d:{target database} the TPC database you wish to benchmark
\u:{username} login name to connect to server. For sql
authentication only
ignored if \t option is used
\p:{password} login password to connect to server. For sql
authentication only
ignored if \t option is used
\t use trusted connection notice no : or any following commands
\wh:{2} number of warehouses to use during tests.
Depends on number of warehouses populated in test
database.
\m:{1} number of minutes to execute the test minimum 1 no maximum
\cs:{50} maximum number of delay between queries issued by the
Client.
Any number between 0 and 50 is normal 0 for maximum
throughput
50 for a standard tpc benchmark Client thinking delay
\sp used extended stored procedures instead of single issued
statements
Search WWH ::
Custom Search