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
| Column | Type | Constraints | References | Description |
|---|---|---|---|---|
vendor_id | VARCHAR(255) | PK | vendor.vendor_id | Reference to the Vendor. |
benchmark_id | VARCHAR(255) | PK | benchmark.benchmark_id | Reference to the Benchmark. |
resource_type | ENUM | PK | Kind of resource the score refers to. See ResourceType for the possible values. | |
resource_id | VARCHAR(255) | PK | Reference to the resource (see resource_type). | |
config | JSON | PK | Dictionary of config parameters of the specific benchmark, e.g. {"bandwidth": 4096} | |
framework_version | VARCHAR(255) | The version of the benchmark tool used. | ||
environment | JSON | Extensible environment details (e.g. kernel_version, database_engine_version). | ||
score | FLOAT | NOT NULL | The resulting score of the benchmark. | |
score_breakdown | JSON | Structured derivation of composite scores (e.g. workload profiles): per-component raw values, references, normalized values, weights, and coverage. Null for simple benchmark scores. | ||
note | VARCHAR(255) | Optional note, comment or context on the benchmark score. | ||
status | ENUM | NOT NULL | Status of the resource (active or inactive). See Status for the possible values. | |
observed_at | DATETIME | NOT NULL | Timestamp of the last observation. |
Foreign keys
Enums
ResourceType
Kind of resource a benchmark score refers to.
| Value | Description |
|---|---|
SERVER | Compute server instance. |
DATABASE | Managed database instance. |
Status
Last known status of a resource, e.g. active or inactive.
| Value | Description |
|---|---|
ACTIVE | Active and available resource. |
INACTIVE | Unavailable. For Server/Database: temporary or unknown cause. |
PLANNED_FOR_RETIREMENT | Planned for retirement; only valid for Server and Database. |
RETIRED | Not orderable anymore, but prices may still exist (e.g. active multi-year contracts). Only valid for Server and Database. |