Skip to main content
Matrix42 Self-Service Help Center

Ensuring compliance of Azure Hybrid Benefit for SQL Server

Introduction

This feature is available starting with the version 2.0 of the Azure Hybrid Benefit Data Provider extension. 

Matrix42 Enterprise Service Management allows you to keep track of compliance regarding the usage of Azure Hybrid Benefits licenses for SQL Server.

Currently this feature is available for SQL Server virtual machines only.

The Azure Hybrid Benefit data provider imports SQL virtual machines where Azure Hybrid Benefit is enabled. This allows the system to determine the number of vCores that use Azure Hybrid Benefits.

On the other hand, the system also calculates the number of vCores from SQL licenses that are available for Azure Hybrid Benefits. These are the licenses for the following software products:

  1. Microsoft Corporation SQL Server Enterprise, Non-specific.
  2. Microsoft Corporation SQL Server Standard, Non-specific.

The Azure Hybrid Benefit add-on works correctly and ensures compliance only for software products and license models that come from and are managed by License Intelligence Service (LIS). If you manage your software products without LIS, the add-on will not take into account such data.

Prerequisites

Which licenses are taken into account

For the compliance of Azure Hybrid Benefit for SQL Server, the system takes into account only licenses that match the following criteria:

  1. The license's software product comes from LIS and is one of the following products with the specified license model:
Software Product ID Software Product Name License Model ID License Model Name
681C6B84-136A-4025-9AFC-46FB1F1F196A Microsoft Corporation SQL Server Enterprise Non-specific 60CB9D08-42D6-E111-A1B9-005056B40823 SQL Enterprise 2012 | Core (Full Virtualization on SA; Mobility on SA)
681C6B84-136A-4025-9AFC-46FB1F1F196A Microsoft Corporation SQL Server Enterprise Non-specific A688F4E6-40D6-E111-A1B9-005056B40823 SQL Enterprise 2012 | Core (SPLA; Full Virtualization; Mobility)
681C6B84-136A-4025-9AFC-46FB1F1F196A Microsoft Corporation SQL Server Enterprise Non-specific FD5E984A-1DCF-4912-A5A0-731E9F82351F SQL Enterprise 2016 | Core (Full Virtualization on SA; Mobility on SA)
945D70C0-FAA5-47D0-A156-9D6ED8501FCA Microsoft Corporation SQL Server Standard Non-specific 3D7A8A8F-0FB1-43F0-AEE0-42FE14D2B91D SQL Standard 2012 | Core (No Virtualization; Mobility on SA)
945D70C0-FAA5-47D0-A156-9D6ED8501FCA Microsoft Corporation SQL Server Standard Non-specific 6C63C5A2-40D6-E111-A1B9-005056B40823 SQL Standard 2012 | Core (No Virtualization; Mobility)
945D70C0-FAA5-47D0-A156-9D6ED8501FCA Microsoft Corporation SQL Server Standard Non-specific D5EBC229-F7E8-41FE-B53E-55471CEC85AA SQL Standard 2012 | Core (SPLA; No Virtualization; Mobility)
945D70C0-FAA5-47D0-A156-9D6ED8501FCA Microsoft Corporation SQL Server Standard Non-specific D3DC944D-0655-43DF-A1DD-22E23A196A69 SQL Standard 2016 | Core (No Virtualization; Mobility on SA)
945D70C0-FAA5-47D0-A156-9D6ED8501FCA Microsoft Corporation SQL Server Standard Non-specific 28A1CE77-41C4-4483-B182-6A5D2BA1E126 SQL Standard 2016 | Core (SPLA; No Virtualization ; Mobility)
  1. License type is either Full Version With Maintenance, Maintenance, Maintenance Renewal, Subscription or Subscription Renewal.
  2. License is not expired.
  3. License is not unlimited.

Using the Assign Licenses action

This action is available for both Windows and SQL Azure Hybrid Benefit objects located under Purchased Licenses > Azure Hybrid Benefit in the Licenses application. You need to use it to indicate that the selected licenses are allocated for Azure Hybrid Benefit compliance.

When you run the Assign ​​​​​​​Licenses action for the SQL Server object, a wizard opens where you can add licenses that will be used in Azure. Use the Apply Your Changes button to save the values entered.

ManageAzureHBActionSQL.png

After you have used the action once, the wizard will contain two grids: one for adding licenses and another one for removing licenses that should no longer be counted for Azure Hybrid Benefit compliance.

Keep in mind that dual use period for licenses lasts for 180 days. During this period of time the assigned licenses will also be used to entitle on-premise license requirements and you are permitted to unassign them from the SQL Server object. After it passes, the licenses will be available only for Hybrid Benefits in Azure. For more information, please refer to Understanding the grace period of SQL Server licenses assigned to Azure Hybrid Benefit.

The license conversion object

After you have added a license to the SQL Server object, a license of the Conversion type will be created in the system. This is a technical license that contains all usage rights allocated for Azure Hybrid Benefits. You cannot edit it manually. Changes to the license conversion will be made automatically when the base licenses and/or the SQL Server object are updated.

Only one license conversion is created regardless of how many base licenses have been added to the Azure Hybrid Benefit object. The validity of the license conversion object is essential for the Azure Hybrid Benefit compliance.

The license conversion object becomes invalid in the following cases:

  • All base licenses expire.
  • All base licenses become invalid for any reason.

Calculations

Data from the Azure portal

The Matrix42 Enterprise Service Management system retrieves the following data from the Azure portal:

  1. The sum of vCores from SQL Server Enterprise virtual machines,
  2. The sum of vCores from SQL Server Standard virtual machines.

Calculating the amounts of vCores supplied by licenses for correct entitlement

Only the number of vCores is relevant for SQL Azure Hybrid Benefit compliance.

ESM entitles virtual machines with available licenses according to the following order:

  1. Each SQL Server Enterprise virtual machine in Azure is entitled with SQL Server Enterprise license under SA.
  2. Each SQL Server Standard virtual machine in Azure is entitled with SQL Server Standard license under SA.
  3. Each SQL Server Enterprise virtual machine in Azure is entitled with SQL Server Standard license under SA. In this case 4 usage rights from an SQL Server Standard license are required to entitle 1 vCore of an SQL Server Enterprise virtual machine.
  4. Each SQL Server Standard virtual machine in Azure is entitled with SQL Server Enterprise license under SA. In this case 1 usage right from an SQL Server Enterprise license entitles 4 vCores of an SQL Server Standard virtual machine.

Checking the Azure Hybrid Benefit compliance

You can check the compliance status on the preview of the Azure Hybrid Benefit object located under Purchased Licenses > Azure Hybrid Benefit in the Licenses application.

AzureHBOjectSQL.png