Your Browser is Out of Date

Nytro.ai uses technology that works best in other browsers.
For a full experience use one of the browsers below
Dell PowerStore with Azure Arc-enabled Data Services
Executive summary Azure Arc-enabled SQL Managed Instance
Azure Arc-enabled SQL Managed Instance
Usability
Connection modes
Pricing tiers
Data resiliency
Ease of deployment
Performance
MI features and benefits
No tuning required
Lab Architecture
Management toolsets
Hardware Dell PowerStore integration Performance study Lessons learned and environment details Appendix References

Ease of deployment

Ease of deployment

  • It is easy to deploy an Azure SQL MI, as in the following examples. The benefit of using Azure CLI is the repeatable and scripted nature of a deployment. You can now include the data layer into the DevOps pipe.

    Example of an Arc-enabled SQL MI General Purpose deployment:

    az sql mi-arc create --name sqlmi-01 --resource-group PowerStoreAzureArc-RG   --location "East US" --custom-location "edenprairienm"  --dev --replicas 1 `

        --cores-request "2" --cores-limit "8" --memory-request "8Gi" --memory-limit "16Gi" `

        --storage-class-backups "nfs-csi" --storage-class-data "powerstore-xfs" --storage-class-logs "powerstore-xfs" --storage-class-datalogs "powerstore-xfs" `

        --volume-size-backups "500Gi" --volume-size-data "950Gi" --volume-size-logs "100Gi"--volume-size-datalogs "500Gi"

    Example of an Arc-enabled SQL MI Business Critical deployment (two minutes to deploy a fully enabled Always On Group):

    az sql mi-arc create --name bizcrtcl-02 --resource-group PowerStoreAzureArc-RG  --tier BusinessCritical --location "East US" --custom-location "edenprairienm"   --replicas 3 `

        --cores-request "4" --cores-limit "4" --memory-request "8Gi" --memory-limit "10Gi" `

        --storage-class-backups "nfs-csi" --storage-class-data "powerstore-xfs" --storage-class-logs "powerstore-xfs" --storage-class-datalogs "powerstore-xfs" `

        --volume-size-backups "500Gi"  --volume-size-data "950Gi" --volume-size-logs "100Gi"--volume-size-datalogs "500Gi"

    The following is an example of how simple it is to ramp up and ramp down pod resources. This example represents an Arc-enabled SQL MI memory reconfiguration that ramps down from 8GB to 4GB. (For more information, see az sql mi-arc update.)

    # this is for Direct mode

    az sql mi-arc update --name sqlmi-01  --memory-request "4Gi"  --k8s-namespace arc-services-ns --use-k8s

    As storage capacity requirements change, the Dell CSI driver for PowerStore allows storage to be expanded from the Kubernetes control plane. For more details, see the section Dell Container Storage Interface.