SQL Server 2016 AlwaysOn with Managed Disks in Availability Zones

게시자: Keith Mayer
마지막 업데이트: 2017-09-17

This template creates Azure VMs on an existing VNET, and provisions a SQL Server 2016 AlwaysOn Availability Group cluster across Availability Zones

이 ARM(Azure Resource Manager) 템플릿은 Microsoft가 아니라 커뮤니티 구성원에 의해 만들어졌습니다. 각 ARM 템플릿은 Microsoft가 아닌 해당 소유자에 의해 사용이 허가됩니다. Microsoft는 커뮤니티 구성원에 의해 제공 및 라이선스가 부여된 ARM에 대해 책임이 없으며, 보안, 호환성 또는 성능을 검사하지 않습니다. 커뮤니티 ARM 템플릿은 Microsoft 지원 프로그램 또는 서비스에서 지원되지 않고, 어떠한 보증도 없이 있는 그래도 제공됩니다.

매개 변수

매개 변수 이름 설명
location Location for the VM, only certain regions support zones during preview.
namePrefix Naming prefix for each new resource created. 3-char min, 8-char max, lowercase alphanumeric
vmSize Size of the SQL Server VMs to be created
vmCount Number of SQL Server VMs to be created in AlwaysOn Availability Group cluster (Min=2, Max=9)
vmDiskSize Size of each data disk in GB on each SQL Server VM (Min=128, Max=1023)
vmDiskCount Number of data disks on each SQL Server VM (Min=2, Max=32). Ensure that the VM size you've selected will support this number of data disks.
existingDomainName DNS domain name for existing Active Directory domain
adminUsername Name of the Administrator of the existing Active Directory Domain
adminPassword Password for the Administrator account of the existing Active Directory Domain
sqlServiceAccount Name of the user account to be used for the SQL Server service account
sqlServicePassword Password to be used for the SQL Server service account
existingVirtualNetworkRGName Resource Group Name for the existing VNET.
existingVirtualNetworkName Name of the existing VNET.
existingSubnetNames Name of the existing subnets in the existing VNET to which the SQL Server VMs should be deployed
workloadType SQL DB workload type: GENERAL - General workload; DW - Data Warehouse workload; OLTP - Transactional Processing workload
_artifactsLocation Location of resources that the script is dependent on such as linked templates and DSC modules
_artifactsLocationSasToken The sasToken required to access _artifactsLocation. When the template is deployed using the accompanying scripts, a sasToken will be automatically generated.

템플릿 사용

PowerShell

New-AzureRmResourceGroupDeployment -Name <deployment-name> -ResourceGroupName <resource-group-name> -TemplateUri https://raw.githubusercontent.com/azure/azure-quickstart-templates/master/sql-alwayson-md-mult-subnets-zones/azuredeploy.json
Azure PowerShell 설치 및 구성

명령줄

azure config mode arm
azure group deployment create <my-resource-group> <my-deployment-name> --template-uri https://raw.githubusercontent.com/azure/azure-quickstart-templates/master/sql-alwayson-md-mult-subnets-zones/azuredeploy.json
Azure 크로스 플랫폼 명령줄 인터페이스 설치 및 구성