Microsoft cost-based licensing optimization example

  • Release version: Yokohama
  • Updated January 30, 2025
  • 2 minutes to read
  • Summarize
    Summarized using AI
    This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete.

    Summary of Microsoft cost-based licensing optimization example

    This example illustrates how a software asset manager can optimize Microsoft SQL Server licensing costs in a VMware cluster deployment. It focuses on managing SQL Server 2019 Enterprise and Standard Core licenses with Software Assurance across multiple virtual machines (VMs) distributed over three physical hosts.

    Show full answer Show less

    Licensing Options and Cost Comparison

    • Option 1: License all physical hosts at the host level using SQL Server 2019 Enterprise Core licenses. This requires 52 rights total, costing approximately $260,000.
    • Option 2: License each VM separately at the virtual layer using SQL Server 2019 Enterprise Core licenses. This also requires 52 rights total, resulting in the same cost of $260,000.
    • Option 3: Combine licensing at the virtual layer by using both SQL Server 2019 Enterprise Core and Standard Core licenses, applying Enterprise licenses to certain VMs and Standard licenses to others. This reduces the total required rights to 24 Enterprise plus 28 Standard, resulting in an estimated cost of $156,400.

    Key Outcome

    The software asset manager identifies option 3 as the most cost-effective solution. By applying a mix of Enterprise and Standard licenses at the VM level, the organization can save approximately $103,600 compared to licensing the entire cluster with Enterprise licenses alone. This approach enables optimized license utilization and significant cost savings in a clustered VMware environment with mixed SQL Server editions.

    This example demonstrates how a software asset manager can optimize Microsoft SQL Server licensing in a cluster deployment.

    In this example, a software asset manager is managing the following Microsoft SQL Server entitlements:
    Table 1. Microsoft SQL Server entitlements
    Entitlement Name License Type Number of Purchased Rights Cost Per Core
    SQL Server Enterprise Licenses SQL Server 2019 Enterprise Core with Software Assurance 1800 $5000
    SQL Server Standard Licenses SQL Server 2019 Standard Core with Software Assurance 600 $1300

    The following infrastructure is a VMware cluster that consists of three physical hosts. Each physical host contains virtual machines (VMs) that are running various versions and editions of Microsoft SQL Server. These VMs may potentially be moving across all physical hosts within the cluster.

    Microsoft SQL Server cluster infrastructure.
    Based on the available entitlements and the cluster infrastructure, the software asset manager can license the cluster using one of the following options:
    Table 2. Licensing options
    Option Number License Type Licensing Layer Number of Rights Required on Each Host or VM Total Number of Required Rights Total Approximated Cost
    1 SQL Server 2019 Enterprise Core with Software Assurance Physical host layer
    • Host 1: 12 rights
    • Host 2: 16 rights
    • Host 3: 24 rights
    12 rights (Host 1) + 16 rights (Host 2) + 24 rights (Host 3) = 52 rights total 52 rights X $5000 = $260,000
    2 SQL Server 2019 Enterprise Core with Software Assurance Virtual layer
    • VM-1: 4 rights
    • VM-2: 4 rights
    • VM-3: 4 rights
    • VM-4: 4 rights
    • VM-5: 4 rights
    • VM-6: 4 rights
    • VM-7: 4 rights
    • VM-8: 4 rights
    • VM-9: 4 rights
    • VM-10: 8 rights
    • VM-11: 8 rights
    4 rights (VM-1) + 4 rights (VM-2) + 4 rights (VM-3) + 4 rights (VM-4) + 4 rights (VM-5) + 4 rights (VM-6) + 4 rights (VM-7) + 4 rights (VM-8) + 4 rights (VM-9) + 8 rights (VM-10) + 8 rights (VM-11) = 52 rights total 52 rights X $5000 = $260,000
    3 Both SQL Server 2019 Enterprise Core with Software Assurance and SQL Server 2019 Standard Core with Software Assurance Virtual layer
    • SQL Server 2019 Enterprise Core with Software Assurance:
      • VM-1: 4 rights
      • VM-9: 4 rights
      • VM-10: 8 rights
      • VM-11: 8 rights
    • SQL Server 2019 Standard Core with Software Assurance:
      • VM-2: 4 rights
      • VM-3: 4 rights
      • VM-4: 4 rights
      • VM-5: 4 rights
      • VM-6: 4 rights
      • VM-7: 4 rights
      • VM-8: 4 rights
    • SQL Server 2019 Enterprise Core with Software Assurance:

      4 rights (VM-1) + 4 rights (VM-9) + 8 rights (VM-10) + 8 rights (VM-11) = 24 rights total

    • SQL Server 2019 Standard Core with Software Assurance:

      4 rights (VM-2) + 4 rights (VM-3) + 4 rights (VM-4) + 4 rights (VM-5) + 4 rights (VM-6) + 4 rights (VM-7) + 4 rights (VM-8) = 28 rights total

    (24 rights X $5000) + (28 rights X $1300) = $156,400
    The software asset manager determines that option number 3 is the most cost-effective licensing solution for the cluster. By using this licensing option, the software asset manager can achieve a total cost savings of approximately $103,600.