Query Resource Limits
Resource request and limits can be set for base components and assemblies in kdb Insights Enterprise.
Resource requests and limits for assemblies are set by a k8sPolicy.
Resource requests and limits for base components are set in the install configuration.
numbers
The numbers for limits used on this page are not suggestions, and are meant to demonstrate how to use these settings, not recommend values.
Defaults
The default values for components related to the query path are:
component | cpu requests | cpu limits | memory requests | memory limits |
---|---|---|---|---|
resource-coordinator | 100m | 1000m | 128Mi | 256Mi |
aggregator | 500m | 2000m | 1024Mi | 2048Mi |
sg-gateway | 250m | 1000m | 512Mi | 4096Mi |
dap | 100m | 100m | 128Mi | 128Mi |
sm | 1000m | 1000m | 4000Mi | 4000Mi |
Resource limits for base components
To set resource limits for the resource-coordinator, aggregators, and service gateway, set resources
in your install configuration.
service-gateway:
aggregator:
resources:
requests:
memory: "64Mi"
cpu: "250m"
limits:
memory: "128Mi"
cpu: "500m"
sg-gateway:
resources:
requests:
memory: "64Mi"
cpu: "250m"
limits:
memory: "128Mi"
cpu: "500m"
resource-coordinator:
resources:
requests:
memory: "64Mi"
cpu: "250m"
limits:
memory: "128Mi"
cpu: "500m"
Resource limits for storage manager and data access processes
To set requests and limits for your databases set a k8sPolicy for the SM and DAP elements of your assemblies.
spec:
elements:
sm:
resourceAllocation: 5
eoi:
resourceAllocation: 45
eod:
resourceAllocation: 45
dbm:
resourceAllocation: 5
k8sPolicy:
resources:
requests:
memory: "64Mi"
cpu: "250m"
limits:
memory: "128Mi"
cpu: "500m"
dap:
instances:
hdb:
k8sPolicy:
resources:
requests:
memory: "64Mi"
cpu: "250m"
limits:
memory: "128Mi"
cpu: "500m"
Query environment resource limits and requests
Resource limits for query environments are set to match the resource limits of the DAP instances.
For example, the query environment hdb pod hdb-qe
will get the same limits as the hdb
pod.
spec:
queryEnvironment:
enabled: true
size: 1
dap:
instances:
hdb:
k8sPolicy:
resources:
requests:
memory: "64Mi"
cpu: "250m"
limits:
memory: "128Mi"
cpu: "500m"