(DI-2302) Collector for DB Benchmarks
The technical name of the Collector for DB Benchmarks is /DVD/MON_BAT_CL_DB.
Collector makes average SQL queries to benchmark SELECT/INSERT/UPDATE operations on the database and reports the time of those queries
Default KPI delivered with this collector
The following default KPIs are delivered with this collector:
KPI name | Description | Unit | Detail table |
|---|---|---|---|
BAT_DB_INSERT_AG | Average DB insert | ms | No |
BAT_DB_INSERT_MS | DB Insertion benchmark | ms | No |
BAT_DB_SELECT_AG | Average DB select | ms | No |
BAT_DB_SELECT_MS | DB Select benchmark | ms | No |
BAT_DB_UPDATE_AG | Average DB update | ms | No |
BAT_DB_UPDATE_MS | DB Update benchmark | ms | No |
Parameters
The following parameters are used for this collector:
Parameter name | Description |
|---|---|
NUM_RECORDS | Default 10 000. Specifies how many rows will be inserted/deleted/updated during benchmarking. |