none
How does MAP display Virtual Processor counts in different reports

    Question

  • When licensing SQL per VM by core, the terms virtual processor (or virtual thread or vCPU) and virtual core are interchangeable as they mean the same thing from a licensing perspective. It is important to identify the data in MAP that is a count of the number of Virtual Processors per VM as each vCPU requires a SQL core licence subject to a minimum of 4 per VM.

    1. From reading the MAP sample data of 220713 it appears that the Total Number of Virtual Processors shown in the SQL Server License Tracking tab of the SQL Server Usage Tracker Report is the same as the Virtual Machine Number of Cores shown in the Hyper-V Host and Guest Details tab of the VM Report (Virtual Processor = Virtual Core), Is this correct?

    2. In respect of the data in the Virtual Machine Number of Processors & Virtual Machine Number of Cores columns of the VM report, please can you explain what the data represents in each column and how MAP calculates those values?

    3. I suspect that the column headings are misleading to me and that Virtual Machine Number of Processors = Physical Processors (also shown as Number of Processors when referring to VMs in the SQL Server Instance Details of the SQL Server Usage Tracker report) that are actually supporting the VM and that Virtual Machine Number of Cores = Virtual Processors (vCPUs) that are actually assigned to the VM. Is this correct?

    4. Is the Number of Processors shown for Virtual Machines in the SQL Server Instance Details Tab of the SQL Server Usage Tracker report the result of the following calculation - Logical Processors or Virtual Processors (supporting VM) divided by Cores (Cores) or Threads if HT turned on (LP) per Physical Processor - as this calculation is the number of Processor Licences required when licensing VMs independently of the Physical Host?

    Nigel

    Addition:

    Hi Michael

    I would really appreciate it if you or one of your team could look at this query please.

    Thanks

    Nigel

    • Edited by NigelpmW Tuesday, November 26, 2013 8:13 PM Request for Response
    Saturday, November 09, 2013 3:41 PM