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 these 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 KPIs 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 insert 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
CALC_AVG_FOR_TIME_IN_HOURS	This parameter defines the number of hours which the collected KPI values are to be used for the calculation of the average benchmarking value. The default value is 1 (one hour back). This means that the average benchmarking value is calculated based on the related KPI values collected in the last hour. Increasing this value, might have an impact on the performance of this collector as more values need to be processed to calculate the average value
NUM_RECORDS	Defines how many rows will be inserted, deleted and updated during benchmarking. Default value: 10,000