SQL Server: Reference

Refer to the information below for descriptions of indicators and table columns on the SQL Server page.

Indicator

Indicator	Description
Total resources	The total number of resources integrated with Snow Atlas.
BYOL	The number of resources that use a Bring Your Own License (BYOL) licensing model.
Eligible	The number of resources that are not BYOL-configured, but eligible for conversion.
Not applicable	The number of resources that are not eligible for BYOL.
BYOL resource coverage	The percentage of BYOL-entitled resources that use a BYOL licensing model. Resources that are Not applicable are excluded from this value.

Resource table

Column	Description
Resource name	The user-created name of the resource.
Resource ID	The unique identifier assigned to the resource by the cloud provider.
Resource type	The type of resource. Only SQL Server resources are shown in the table. These resources include: SQL Server on Azure VM (SqlVirtualMachine) Azure SQL Managed Instance (SqlManagedInstance) Azure SQL Database (SqlDatabase) Azure Elastic Pool (SqlElasticPool)
vCPU	The number of vCPUs assigned to the resource. This column will be blank for resources with a License status of Not Applicable, or when the vCPU count cannot be calculated. For instances with constrained vCPU, this column reflects only the number of active vCPUs. This is because, unlike Windows Server licensing, SQL Server licenses are only required for active vCPUs. For more information on constrained vCPU, see Constrained vCPU sizes for database workloads .
Licenses required	The number of SQL Server licenses required for the resource to qualify for Azure Hybrid Benefit. SQL Server Enterprise and Standard core licenses with Software Assurance qualify, as do SQL Server core license subscriptions. One SQL Server Enterprise license has the same coverage as four Standard licenses. The number of licenses required differs depending on the type of resource. For more information, see How licenses apply to Azure resources .
Purchase model	The pricing model used to purchase the SQL Server license. For information on the differences between a vCore-based purchasing model and a DTU-based purchasing model, see Purchasing models - Azure SQL Database .
Compute tier	The compute tier the resource is assigned to. A compute tier is a pre-configured bundle of compute resources provisioned for different user needs.
Service tier	The service tier the resource is assigned to. A service tier is a model of pre-configured performance and security capabilities provisioned for different user needs.
Subscription ID	The unique identifier for the cloud subscription that contains the resource.
Subscription name	The name of the subscription account that contains the resource.
Date created (UTC)	The date and time the resource was created in UTC time.
License status	The license status of the resource's operating system. BYOL: The license is BYOL-configured. Eligible: The license is not BYOL-configured, but is eligible for conversion. Not applicable: The license is ineligible for BYOL. The SQL resource configurations that are ineligible include: Single vCore Serverless, Single DTU, Elastic Pool vCore, Elastic Pool DTU.
Resource group	The logical container the resource is grouped within in the cloud providers' portal.
Cloud provider	The cloud provider that hosts the resource.
Region	The geographical location where the resource is hosted.
Connector name	The unique identifier of the cloud connector used to fetch the resource data.