(DI-2305) Collector for DB Benchmarks

Owned by SNP
May 03, 2023
1 min read

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

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

Parameter name

Description

NUM_RECORDS

Default 10 000. Specifies how many rows will be inserted/deleted/updated during benchmarking.