(DI-2311) 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

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

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.