dbperfchk
Use the dbperfchk program to provide metrics to test database performance in a replication environment.
Usage
dbperfchk.exe <options>
Argument | Description |
|---|---|
-a, --all | Run all tests |
-ert, --expected-replication-time <N> | The amount of time (in minutes) to wait for replication to complete before timing out; default 10 minutes. |
-xt, --maxThreads <N> | Maximum number of threads to test (default 5) |
-mt, --minThreads <N> | Minimum number of threads to test (default 1) |
-mcl, --multi-commit-latency | Run concurrent commit latency test |
-mcr, --multi-commit-replication | Run a multi-threaded test of replication throughput using only one replicated server |
-mcrt, --multi-commit-replication-thorough | Run a multi-threaded test of replication throughput using all replicated servers (auto-detect) |
-port, --port <port> | Replication secondary server port |
-secondary, --secondary <address> | Replication secondary server address |
-scl, --single-commit-latency | Run single-threaded commit latency test |
-sro, --single-read-ops | Run a single-threaded read-only operations-per-second test |
-t --time <N> | Number of milliseconds to run for |
Examples
To test all replication partners running a multi-threaded test:
dbperfchk.exe -mcrt -mt 2 -xt 3
To test the local instance database latency:
dbperfchk.exe -scl
or,
dbperfchk.exe -mcl
To check database performance on 10.0.xx.xx server with port 5555 in 60 seconds with a minimum thread of 4 and maximum thread of 6:
dbperfchk.exe -a -xt 6 -mt 4 -port 5555 -secondary 10.0.xx.xx -t 60000
To check database performance on 10.0.xx.xx server with port 5555 in 60 seconds with single-threaded read-only test:
dbperfchk.exe -sro -port 5555 -secondary 10.0.xx.xx -t 60000