(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

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.