SQL Server Resource Provider for AZ VM Terms

Milan 66 Reputation points
2020-06-11T12:31:02.937+00:00

Hi,

I want to ask because I was reading documentation about SQL Server on Azure VM but it´s still not clear for me. So my questions:

  1. SQL Server Resource Provider for Azure VMs need to be deployed everytime when Azure VM is running SQL Server? No matter if it´s free (Developer, Express) SQL version Azure VM, still must be SQL Resource Provider deployed? If yes then where can I find some microsoft terms about this?
  2. For example if we had multiple SQL Server instances with multiple versions (Enterprise, Standard, Developer) on single Azure VM how this three editions can be provided to SQL Server Resource provider?
  3. If we have Visual Studio Enterprise license keys for SQL Servers, can be this MSDN keys used to Azure Hybrid Benefit?
SQL Server on Azure Virtual Machines
{count} votes

1 answer

Sort by: Most helpful
  1. Ronen Ariely 15,106 Reputation points
    2020-06-11T14:11:37.787+00:00

    Good day,

    SQL Server Resource Provider for AZ VM is a provider which you need to register once in the subscription level for all SQL Server Instances inside all Virtual Machines at that subscriber. This is done in the Azure level. This is Azure Provider.

    az provider register --namespace Microsoft.SqlVirtualMachine   
    

    Next you need to register the virtual machine with the resource provider. This is done once for each VM you want to use.

    You can select one of three types of management mode: Full, Lightweight, or NoAgent

    You can select the mode according to your needs but there are limitations according to the server instance version (version and not edition). Version means for example SQL Server 2008R2 or SQL Server 2019. Edition means Enterprise, Standard, Developer for example. There is limitation for versions. For example, SQL Server version 2008R2 supports only NoAgent mode.

    Note: Only license type and edition updates are available with the LightWeight SQL IaaS extension mode. If you need to enable all manageability features for the SQL virtual machine then you need to upgrade to Full.

    You can do all steps in the Portal or using Powershell.

    SQL Server Resource Provider for Azure VMs need to be deployed everytime when Azure VM is running SQL Server?

    Only if you want to use the Azure SQL Server configuration management.

    No matter if it´s free (Developer, Express) SQL version Azure VM, still must be SQL Resource Provider deployed?

    Yes, once for each VM that you want to manage.

    If yes then where can I find some microsoft terms about this?...

    1) You can find full tutorial in how to enable it here.

    Note: After you register the provider in the virtual machine, Using the portal, You can only configure single specific SQL Server billed based which suppose to be the according to the edition which you use on the server. I am not sure what you should configure if you have two different edition but I assume that you should select the higher option. So if you have both Express and Enterprise then you should select Enterprise. This way you get the options that Enterprise has.

    0 comments No comments