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"