Deploy SQL Server on Azure Local, version 23H2
Applies to: Azure Local, version 23H2
This topic provides guidance on how to deploy SQL Server on Azure Local, version 23H2.
Solution overview
Azure Local provides a highly available, cost efficient, flexible platform to run SQL Server and Storage Spaces Direct. Azure Local can run Online Transaction Processing (OLTP) workloads, data warehouse and BI, and AI and advanced analytics over big data.
The platform's flexibility is especially important for mission critical databases. You can run SQL Server on virtual machines (VMs) that use either Windows Server or Linux, which allows you to consolidate multiple database workloads and add more VMs to your Azure Local environment as needed. Azure Local also enables you to integrate SQL Server with Azure Site Recovery to provide a cloud-based migration, restoration, and protection solution for your organization’s data that is reliable and secure.
Deploy SQL Server
This section describes at a high level how to acquire hardware for SQL Server on Azure Local. Information on setting up SQL Server, monitoring and performance tuning, and using High Availability (HA) and Azure hybrid services is included.
Step 1: Acquire hardware from the Azure Local Catalog
First, you'll need to procure hardware. The easiest way to do that is to locate your preferred Microsoft hardware partner in the Azure Local Catalog and purchase an integrated system or premium solution with the Azure Stack HCI operating system preinstalled. In the catalog, you can filter to see vendor hardware that is optimized for this type of workload.
Otherwise, use a validated system from the catalog and deploy it on that hardware.
For details on Azure Local deployment options, see Deploy the Azure Stack HCI operating system.
Next, deploy Azure Local, version 23H2 using Azure portal or deploy Azure Local, version 23H2 using an Azure Resource Manager deployment template.
Step 2: Install SQL Server on Azure Local
You can install SQL Server on VMs running either Windows Server or Linux depending on your requirements.
For instructions on installing SQL Server, see:
Step 3: Monitor and performance tune SQL Server
Microsoft provides a comprehensive set of tools for monitoring events in SQL Server and for tuning the physical database design. Tool choice depends on the type of monitoring or tuning that you want to perform.
To ensure the performance and health of your SQL Server instances on Azure Local, see Performance Monitoring and Tuning Tools.
For tuning SQL Server 2017 and SQL Server 2016, see Recommended updates and configuration options for SQL Server 2017 and 2016 with high-performance workloads.
Step 4: Use SQL Server high availability features
Azure Local leverages Windows Server Failover Clustering with SQL Server (WSFC) to support SQL Server running in VMs in the event of a hardware failure. SQL Server also offers Always On availability groups (AG) to provide database-level high availability that is designed to help with application and software faults. In addition to WSFC and AG, Azure Local can use Always On Failover Cluster Instance (FCI), which is based on Storage Spaces Direct technology for shared storage.
These options all work with the Microsoft Azure Cloud witness for quorum control. We recommend using cluster AntiAffinity rules in WSFC for VMs placed on different physical nodes to maintain uptime for SQL Server in the event of host failures when you configure Always On availability groups.
Step 5: Set up Azure hybrid services
There are several Azure hybrid services that you can use to help keep your SQL Server data and applications secure. Azure Site Recovery is a disaster recovery as a service (DRaaS) solution. For more information about using this service to protect the SQL Server back end of an application to help keep workloads online, see Set up disaster recovery for SQL Server.
Azure Backup lets you define backup policies to protect enterprise workloads and supports backing up and restoring SQL Server consistency. For more information about how to back up your on-premises SQL data, see Install Azure Backup Server and Back up Azure Local virtual machines with MABS.
Alternatively, you can use the SQL Server Managed Backup feature in SQL Server to manage Azure Blob Storage backups.
For more information about using this option that is suitable for off-site archiving, see:
- Tutorial: Use Azure Blob Storage with SQL Server.
- Quickstart: SQL backup and restore to Azure Blob storage service.
In addition to these backup scenarios, you can set up other database services that SQL Server offers, including Azure Data Factory and Azure Feature Pack for Integration Services (SSIS).
Next steps
For more information about working with SQL Server, see: Tutorial: Getting Started with the Database Engine.