Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Info

Microsoft SQL SERVER Server licensing information provided within IDERA SQL Inventory Manager is based on your system information and is only for guidance.

...

  • SQL Server. Displays the name of the SQL Server instance.
  • Virtual. Displays "Yes" if the instance resides on a virtual machine or "No" if the machine is physical.
  • MS SQL Server Version. Displays the version number for the installed SQL Server.
  • Fully Licensed with SA. Check this box to remove the license count for the instance. You can also manage this setting in the Instances > SQL Licensing view.
  • CPU. Displays information about the CPU in use.
  • # of Sockets. Displays the number of cores per processor, whether physical or virtual.
  • # of Logical Processors. Displays the total number of processors.
  • Total # of Cores. Displays the sum of all the cores on a system. For example, if a system includes six cores per processor and contains two processors, then the total # of cores is 12. note that the sum does not mix physical and virtual cores but displays each type as a separate line. Check the Virtual column for each row to determine if the core is virtual (displays "Yes") or physical (displays "No").
  • Core Factor. Displays a numerical value that determines the number of core licenses necessary. While an administrator can change this value in this field or in the Core Factor Table, this number is provided by Microsoft based on the CPU in use.
  • Total Possible Core Licenses. Displays the product of the total number of cores on a system multiplied by the Core Factor.
  • Comments. Allows you to enter notes about this license.

Make any changes you want to the provided fields, and then click SAVE.

 Need more help? Search the IDERA Customer Support Portal.

Excerpt
SQL Inventory Manager lets you discover and visualize your SQL Server environment. Learn more > >