Skip to main content

benchmark_score

Results of running Benchmark scenarios on Servers or managed Databases.

Primary key: vendor_id, benchmark_id, resource_type, resource_id, config. See the version history of this table on dbdocs.io.

Columns​

ColumnTypeConstraintsReferencesDescription
vendor_idVARCHAR(255)PKvendor.vendor_idReference to the Vendor.
benchmark_idVARCHAR(255)PKbenchmark.benchmark_idReference to the Benchmark.
resource_typeENUMPKKind of resource the score refers to. See ResourceType for the possible values.
resource_idVARCHAR(255)PKReference to the resource (see resource_type).
configJSONPKDictionary of config parameters of the specific benchmark, e.g. {"bandwidth": 4096}
framework_versionVARCHAR(255)The version of the benchmark tool used.
environmentJSONExtensible environment details (e.g. kernel_version, database_engine_version).
scoreFLOATNOT NULLThe resulting score of the benchmark.
score_breakdownJSONStructured derivation of composite scores (e.g. workload profiles): per-component raw values, references, normalized values, weights, and coverage. Null for simple benchmark scores.
noteVARCHAR(255)Optional note, comment or context on the benchmark score.
statusENUMNOT NULLStatus of the resource (active or inactive). See Status for the possible values.
observed_atDATETIMENOT NULLTimestamp of the last observation.

Foreign keys​

  • vendor_id → vendor (vendor_id)
  • benchmark_id → benchmark (benchmark_id)

Enums​

ResourceType​

Kind of resource a benchmark score refers to.

ValueDescription
SERVERCompute server instance.
DATABASEManaged database instance.

Status​

Last known status of a resource, e.g. active or inactive.

ValueDescription
ACTIVEActive and available resource.
INACTIVEUnavailable. For Server/Database: temporary or unknown cause.
PLANNED_FOR_RETIREMENTPlanned for retirement; only valid for Server and Database.
RETIREDNot orderable anymore, but prices may still exist (e.g. active multi-year contracts). Only valid for Server and Database.