Azure

Azure Arc Data Services Sizing Tool & Calculator for SQL MI PostGreSQL

Planning your Azure Arc Data Services deployment is a critical first step. This interactive sizing tool helps you accurately estimate the vCore and RAM resource requirements for your specific configuration. Whether you’re deploying SQL Managed Instances or PostgreSQL Hyperscale server groups, use this calculator to align with official Microsoft guidance and ensure your Kubernetes cluster is properly provisioned for optimal performance. Simply input your desired setup below to get a comprehensive sizing estimate. Azure Arc Data Services Sizing Tool

Azure Arc Data Services Sizing Tool

Estimate the resource requirements for your deployment.

Data Controller

Corresponds to Kubernetes CPU 'requests'. 1 vCore = 1 Kubernetes CPU unit = 1000m (millicores). This is the guaranteed CPU for the process.
Corresponds to Kubernetes memory 'requests' (e.g., 4Gi). This is the guaranteed memory for the process.

SQL Managed Instance

Instance Profile 1

General Purpose is for standard workloads. Business Critical provides high availability with 3 replicas (3x resource cost).
Corresponds to Kubernetes CPU 'requests' for each SQL instance. 1 vCore = 1 Kubernetes CPU unit.
Corresponds to Kubernetes memory 'requests' for each SQL instance.
The number of separate SQL Managed Instances to deploy with this configuration.

PostgreSQL Hyperscale

Server Group Profile 1

The number of worker nodes in each PostgreSQL server group. Does not include the coordinator node.
The vCores for the coordinator and each worker node in the server group.
The RAM in GB for the coordinator and each worker node in the server group.
The number of separate PostgreSQL server groups to deploy with this configuration.
Understanding Kubernetes Resources (vCores & RAM)

The vCores and RAM you specify in this tool translate directly to resource requests and limits in Kubernetes, which is the underlying platform for Azure Arc Data Services.

CPU (vCores)

CPU resources are measured in Kubernetes CPU units. One vCore in this tool is equivalent to one Kubernetes CPU unit. This can also be expressed as 1000m (millicores or millicpu). For example, specifying 2 vCores for a service sets its Kubernetes CPU request to '2' or '2000m'. Kubernetes uses this value to guarantee that the service gets the requested CPU power.

Memory (RAM)

Memory is measured in bytes. Kubernetes understands units like Gi (Gibibytes) and Mi (Mebibytes). This tool simplifies it to GB (Gigabytes) for ease of use. When you enter 4 GB of RAM, it sets the Kubernetes memory request to a value like '4Gi', ensuring the service has that much memory reserved for it.

Key takeaway: The values you enter are used to define the minimum guaranteed resources (requests) for each component in your Kubernetes cluster, ensuring stable performance.

Example Sizing Calculation

This example demonstrates a common deployment scenario. Click the button below to load these values into the tool and see the calculation in action.

  • Data Controller: 4 vCores, 4 GB RAM
  • SQL MI (General Purpose): 1 instance with 2 vCores, 4 GB RAM
  • SQL MI (Business Critical): 1 instance with 4 vCores, 8 GB RAM (resources are x3 for replicas)
  • PostgreSQL Hyperscale: 1 group with 2 workers, each node (coordinator + workers) having 2 vCores, 4 GB RAM

Breakdown:

  • Data Controller: 4 vCores, 4 GB RAM
  • SQL MI (GP) Total: 2 vCores, 4 GB RAM
  • SQL MI (BC) Total: (4 vCores * 3 replicas) = 12 vCores, (8 GB RAM * 3 replicas) = 24 GB RAM
  • PostgreSQL Total: (1 coordinator + 2 workers) * 2 vCores = 6 vCores, (1 coordinator + 2 workers) * 4 GB RAM = 12 GB RAM

Example Total: 24 vCores and 44 GB RAM required across the cluster.

Disclaimer: The Questions and Answers provided on https://gigxp.com are for general information purposes only. We make no representations or warranties of any kind, express or implied, about the completeness, accuracy, reliability, suitability or availability with respect to the website or the information, products, services, or related graphics contained on the website for any purpose.

What's your reaction?

Excited
0
Happy
0
In Love
0
Not Sure
0
Silly
0

Comments are closed.

More in:Azure

Next Article:

0 %