在 Azure 专用主机上运行 SQL Server VMRun SQL Server VM on an Azure Dedicated Host

适用于: Azure VM 上的 SQL Server

本文详细介绍了如何将 SQL Server 虚拟机 (VM) 和 Azure 专用主机结合使用。This article details the specifics of using a SQL Server virtual machine (VM) with Azure Dedicated Host. 有关 Azure 专用主机的其他信息,请参阅博客文章 Azure 专用主机简介Additional information about Azure Dedicated Host can be found in the blog post Introducing Azure Dedicated Host.

概述Overview

Azure 专用主机 是一种提供物理服务器的服务,物理服务器可托管专用于一个 Azure 订阅的一个或多个虚拟机。Azure Dedicated Host is a service that provides physical servers - able to host one or more virtual machines - dedicated to one Azure subscription. 专用主机是在 Azure 的数据中心使用的相同物理服务器,作为资源提供。Dedicated hosts are the same physical servers used in Azure's data centers, provided as a resource. 你可以在区域和容错域中预配专用主机。You can provision dedicated hosts within a region, and fault domain. 然后,可以按照最能满足你的需要的配置将 VM 直接放入预配的主机中。Then, you can place VMs directly into your provisioned hosts, in whatever configuration best meets your needs.

限制Limitations

  • 并非所有 VM 系列都在专用主机上受支持,VM 系列可用性因区域而异。Not all VM series are supported on dedicated hosts, and VM series availability varies by region. 有关详细信息,请参阅 Azure 专用主机概述For more information, see Overview of Azure Dedicated Hosts.

授权Licensing

将 SQL Server VM 放置在 Azure 专用主机中后,有两个不同的许可选项可供选择。You can choose between two different licensing options when you place your SQL Server VM in an Azure Dedicated Host.

  • SQL VM 许可:这是现有的许可选项,选择它后,可以单独为每个 SQL Server VM 许可付费。SQL VM licensing: This is the existing licensing option, where you pay for each SQL Server VM license individually.
  • 专用主机许可:这是适用于 Azure 专用主机的新许可模型,这种模式将 SQL Server 许可证进行捆绑并在主机级别付费。Dedicated host licensing: The new licensing model available for the Azure Dedicated Host, where SQL Server licenses are bundled and paid for at the host level.

用于使用现有 SQL Server 许可证的主机级选项:Host-level options for using existing SQL Server licenses:

  • SQL Server Enterprise Edition Azure 混合权益 (AHB)SQL Server Enterprise Edition Azure Hybrid Benefit (AHB)
    • 适用于具有 SA 或订阅的客户。Available to customers with SA or subscription.
    • 授权使用所有可用的物理核心,可享受无限的虚拟化(最多可达主机支持的最大 vCPU 数)。License all available physical cores and enjoy unlimited virtualization (up to the max vCPUs supported by the host).
  • 10 月 1 日前获取的 SQL Server 许可证SQL Server licenses acquired before October 1
    • SQL Server Enterprise Edition 同时提供主机级别和按 VM 的许可证选项。SQL Server Enterprise edition has both host-level and by-VM license options.
    • Microsoft SQL Server Standard Edition 仅提供按 VM 的许可证选项。SQL Server Standard edition has only a by-VM license option available.
  • 如果未选择 SQL Server 专用主机级别选项,则可以在单个 VM 级别选择 SQL Server AHB,就像多租户 VM 的操作方式一样。If no SQL Server dedicated host-level option is selected, you may select SQL Server AHB at the level of individual VMs, just as you would with multi-tenant VMs.

设置Provisioning

将 SQL Server VM 预配到专用主机的操作与其他任何 Azure 虚拟机一样。Provisioning a SQL Server VM to the dedicated host is no different than any other Azure virtual machine. 可以使用 Azure PowerShellAzure 门户Azure CLI 执行此操作。You can do so using Azure PowerShell, the Azure portal, and the Azure CLI.

将现有 SQL Server VM 添加到专用主机的过程需要停机,但不会影响数据,也不会造成数据丢失。The process of adding an existing SQL Server VM to the dedicated host requires downtime, but will not affect data, and will not have data loss. 尽管如此,所有数据库(包括系统数据库)在移动之前都应进行备份。Nonetheless, all databases, including system databases, should be backed up prior to the move.

虚拟化Virtualization

专用主机的一个优点是无限虚拟化。One of the benefits of a dedicated host is unlimited virtualization. 例如,在拥有 64 个 vCore 许可证的情况下可将主机配置为拥有 128 个 vcore,因此可以配置双倍的 vCore,但只需支付 SQL Server 许可证费用的一半。For example, you can have licenses for 64 vCores, but you can configure the host to have 128 vCores, so you get double the vCores but pay only half of what you would for the SQL Server licenses.

由于是你的主机,因此你有权将虚拟化设置为 1:2 的比例。Because since it's your host, you are eligible to set the virtualization with a 1:2 ratio.

常见问题解答FAQ

问:如何对 Azure 专用主机上的 Windows Server/SQL Server 许可证使用 Azure 混合权益?Q: How does the Azure Hybrid Benefit work for Windows Server/SQL Server licenses on Azure Dedicated Host?

答:通过使用 Azure 混合权益,客户可以将现有 Windows Server 和 SQL Server 许可证的价值与软件保障或合格的订阅许可证结合利用,从而在 Azure 专用主机上按折扣费率付费。A: Customers can use the value of their existing Windows Server and SQL Server licenses with Software Assurance, or qualifying subscription licenses, to pay a reduced rate on Azure Dedicated Host using Azure Hybrid Benefit. Windows Server Datacenter 和 SQL Server Enterprise Edition 客户在获得整个主机的许可并使用 Azure 混合权益后,可获得无限虚拟化(根据基础服务器的物理容量,在主机上部署尽可能多的 Windows Server 虚拟机)。Windows Server Datacenter and SQL Server Enterprise Edition customers get unlimited virtualization (deploy as many Windows Server virtual machines as possible on the host subject to the physical capacity of the underlying server) when they license the entire host and use Azure Hybrid Benefit. Azure 专用主机中的所有 Windows Server 和 SQL Server 工作负载还有资格获得 Windows Server 和 SQL Server 2008/R2 的扩展安全更新,而无需额外付费。All Windows Server and SQL Server workloads in Azure Dedicated Host are also eligible for Extended Security Updates for Windows Server and SQL Server 2008/R2 at no additional charge.

后续步骤Next steps

有关详细信息,请参阅以下文章:For more information, see the following articles: