(DI-2308) Collector for DB Benchmarks
The technical name of the Collector for DB Benchmarks is /DVD/MON_BAT_CL_DB.
This collector executes SQL queries with testing records to calculate the benchmark metrics for the SELECT/INSERT/UPDATE operations on the database and reports the calculated times of those executed queries. Additionally, it calculates the average times for SELECT/INSERT/UPDATE operations (by default, it calculates the average value from the times collected in the last one hour for the specific operation).
Default KPI delivered with this collector
The following default KPIs are delivered with this collector:
KPI name | Description | Unit | Collected on |
|---|---|---|---|
BAT_DB_INSERT_AG | Average DB insert | ms | Central system |
BAT_DB_INSERT_MS | DB Insertion benchmark | ms | Remote system |
BAT_DB_SELECT_AG | Average DB select | ms | Central system |
BAT_DB_SELECT_MS | DB Select benchmark | ms | Remote system |
BAT_DB_UPDATE_AG | Average DB update | ms | Central system |
BAT_DB_UPDATE_MS | DB Update benchmark | ms | Remote system |
Parameters
The following parameters are used for this collector:
Parameter name | Description |
|---|---|
CALC_AVG_FOR_TIME_IN_HOURS | This parameter defines for how long time period back in hours are collected KPI values used for calculation of the benchmarking average value. Default value is 1 (one hour back). This means that average benchmarking value is calculated based on the related KPI values collected in the last one hour. If this value is increased, this might have an impact on the performance of this collector as more values need to be processed to calculate the average value. |
NUM_RECORDS | This parameter specifies how many rows will be selected/inserted/updated into the testing table during the collector’s execution to calculate the benchmarking metrics. Default value is 10 000 records. It means that 10 000 testing records will be inserted/deleted/updated into the testing table to be able to calculate the specific benchmarking metric. |