Number of Total Cores for SQL Server in a virtual environment RRS feed

  • Question

  • Using MAP, is it possible to get a count of the total number of cores if we have licensed the VM hosts for max virtualization?  For example we licensed all cores on a VM host  but MAP seems to show more cores based on the sql server guest machines.  I'm guessing this is because virtual cores is not the same as physical cores.

    How can I get an accurate count of cores  for SQL Server in a virtual environment by using MAP?

    Wednesday, December 7, 2016 4:23 PM

All replies

  • You need to use your VMware credentials and collect HOST information and not calculate your cores based on guests. 

    Environment -> Collect inventory data -> WMware computers

    Once you have the inventory go to Server Virtualization and double click on the Virtual Machine Discovery.
    Then click on Generate Virtual Machine Report to see your host procs and cores.


    Tuesday, December 27, 2016 7:18 PM