server
Server types.
Primary key: vendor_id, server_id. 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. |
server_id | VARCHAR(255) | PK | Unique identifier, as called at the Vendor. | |
name | VARCHAR(255) | NOT NULL | Human-friendly name. | |
api_reference | VARCHAR(255) | NOT NULL | How this resource is referenced in the vendor API calls. This is usually either the id or name of the resource, depending on the vendor and actual API endpoint. | |
display_name | VARCHAR(255) | NOT NULL | Human-friendly reference (usually the id or name) of the resource. | |
description | VARCHAR(255) | NOT NULL | Short description. | |
family | VARCHAR(255) | Server family, e.g. General-purpose machine (GCP), or M5g (AWS). | ||
vcpus | INTEGER | NOT NULL | Default number of virtual CPUs (vCPU) of the server. | |
hypervisor | VARCHAR(255) | Hypervisor of the virtual server, e.g. Xen, KVM, Nitro or Dedicated. | ||
cpu_allocation | ENUM | NOT NULL | Allocation of CPU(s) to the server, e.g. shared, burstable or dedicated. See CpuAllocation for the possible values. | |
cpu_cores | INTEGER | Default number of CPU cores of the server. Equals to vCPUs when HyperThreading is disabled. | ||
cpu_speed | FLOAT | Vendor-reported maximum CPU clock speed (GHz). | ||
cpu_architecture | ENUM | NOT NULL | CPU architecture (arm64, arm64_mac, i386, or x86_64). See CpuArchitecture for the possible values. | |
cpu_manufacturer | VARCHAR(255) | The manufacturer of the primary processor, e.g. Intel or AMD. | ||
cpu_family | VARCHAR(255) | The product line/family of the primary processor, e.g. Xeon, Core i7, Ryzen 9. | ||
cpu_model | VARCHAR(255) | The model number of the primary processor, e.g. 9750H. | ||
cpu_l1d_cache | INTEGER | L1 data cache size (KiB). | ||
cpu_l1d_cache_total | INTEGER | Total L1 data cache size (KiB) across all cores. | ||
cpu_l1i_cache | INTEGER | L1 instruction cache size (KiB). | ||
cpu_l1i_cache_total | INTEGER | Total L1 instruction cache size (KiB) across all cores. | ||
cpu_l2_cache | INTEGER | L2 cache size (KiB). | ||
cpu_l2_cache_total | INTEGER | Total L2 cache size (KiB) across all cores. | ||
cpu_l3_cache | INTEGER | L3 cache size (KiB). | ||
cpu_l3_cache_total | INTEGER | Total L3 cache size (KiB) across all cores. | ||
cpu_flags | JSON | NOT NULL | CPU features/flags. | |
cpus | JSON | NOT NULL | JSON array of known CPU details, e.g. the manufacturer, family, model; L1/L2/L3 cache size; microcode version; feature flags; bugs etc. | |
ecpus | FLOAT | The effective "real-world" core count, calculated by dividing the maximum multi-core SCore by the single-core SCore. | ||
scalability | FLOAT | Measures how efficiently the server scales from a single core performance to using multiple cores. A score of 100%% means perfect linear scaling with zero performance loss. | ||
hw_virt | BOOL | If hardware virtualization (e.g. KVM) is supported. | ||
memory_amount | INTEGER | NOT NULL | RAM amount (MiB) reported by the vendor. | |
memory_amount_actual | INTEGER | Actual RAM amount (MiB) measured on the instance via lstopo or other tool. This amount might not match the vendor-reported memory due to the BIOS or the hypervisor reserving a small percentage. | ||
memory_generation | ENUM | Generation of the DDR SDRAM, e.g. DDR4 or DDR5. See DdrGeneration for the possible values. | ||
memory_speed | INTEGER | DDR SDRAM clock rate (Mhz). | ||
memory_ecc | BOOL | If the DDR SDRAM uses error correction code to detect and correct n-bit data corruption. | ||
gpu_count | FLOAT | NOT NULL | Number of GPU accelerator(s). | |
gpu_memory_min | INTEGER | Memory (MiB) allocated to the lowest-end GPU accelerator. | ||
gpu_memory_total | INTEGER | Overall memory (MiB) allocated to all the GPU accelerator(s). | ||
gpu_manufacturer | VARCHAR(255) | The manufacturer of the primary GPU accelerator, e.g. Nvidia or AMD. | ||
gpu_family | VARCHAR(255) | The product family of the primary GPU accelerator, e.g. Turing. | ||
gpu_model | VARCHAR(255) | The model number of the primary GPU accelerator, e.g. Tesla T4. | ||
gpus | JSON | NOT NULL | JSON array of GPU accelerator details, including the manufacturer, name, and memory (MiB) of each GPU. | |
storage_size | INTEGER | NOT NULL | Overall size (GB) of the disk(s). | |
storage_type | ENUM | Primary disk type, e.g. HDD, SSD, or NVMe SSD. See StorageType for the possible values. | ||
storages | JSON | NOT NULL | JSON array of disks attached to the server, including the size (GB) and type of each disk. | |
network_speed_baseline | FLOAT | The baseline network performance (Gbps) of the network card. | ||
network_speed_max | FLOAT | The maximum network performance (Gbps) of the network card. | ||
network_storage_speed_baseline | FLOAT | The baseline bandwidth performance of network-attached storage (Gbps). | ||
network_storage_speed_max | FLOAT | The maximum bandwidth performance of network-attached storage (Gbps). | ||
inbound_traffic | FLOAT | NOT NULL | Amount of complimentary inbound traffic (GB) per month. | |
outbound_traffic | FLOAT | NOT NULL | Amount of complimentary outbound traffic (GB) per month. | |
ipv4 | INTEGER | NOT NULL | Number of complimentary IPv4 address(es). | |
average_time_to_start | FLOAT | Average time to start the server (seconds). | ||
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
vendor_id→vendor(vendor_id)
Enums
CpuAllocation
CPU allocation methods at cloud vendors.
| Value | Description |
|---|---|
SHARED | Shared CPU with other virtual server tenants. |
BURSTABLE | CPU that can temporarily burst above its baseline performance. |
DEDICATED | Dedicated CPU with known performance. |
CpuArchitecture
CPU architectures.
| Value | Description |
|---|---|
ARM64 | 64-bit ARM architecture. |
ARM64_MAC | Apple 64-bit ARM architecture. |
I386 | 32-bit x86 architecture. |
X86_64 | 64-bit x86 architecture. |
X86_64_MAC | Apple 64-bit x86 architecture. |
DdrGeneration
Generation of the DDR SDRAM.
| Value | Description |
|---|---|
DDR3 | DDR3 SDRAM. |
DDR4 | DDR4 SDRAM. |
DDR5 | DDR5 SDRAM. |
StorageType
Type of a storage, e.g. HDD or SSD.
| Value | Description |
|---|---|
HDD | Magnetic hard disk drive. |
SSD | Solid-state drive. |
NVME_SSD | NVMe based solid-state drive. |
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. |