Page History
...
| Tip |
|---|
You can type on the bottom section of this view the number of instances you want SQL Inventory Manager to display per page. Click Refresh to apply the changes. |
Options available for
...
a single instance
On the SQL Licensing view, SQL Inventory Manager allows you to perform several actions on a single instance as well as bulk actions on several selected instances.
...
| Tip |
|---|
You can also access most of these options from the gear icon next to the selected instance. To access the instance details view, you can click directly on the instance name. |
Viewing instance details
You can access an instance details view by selecting the instance and clicking View Details on the action items bar or by clicking directly on the instance name. For more information about what information is available on the instance details view, refer to Viewing instance details.
...
By selecting an instance and clicking Edit Tags on the action items bar, SQL Inventory Manager opens a new dialog window where you can add new tags or change the currently assigned tags of the selected instance. You can also find this option by clicking the gear icon next to the respective instance. For more information about editing tags for a specific instance, go to Manage tags for a single instance.
Export
You can export the information displayed in this view as a PDF, XLS, or XML format.
More Actions
Under More Actions you can find additional options: Decommission, Disable Monitoring, Remove, Add SQL Server instance, and Core Factor Table.
...
If you want to disable the monitoring of an instance, select the instance, go to More Actions, and select Disable Monitoring. You can also find this option by clicking the gear icon next to the respective instance. For more information about disabling instances, click here.
Add SQL Server instance
If you want to access the Add SQL Server instance wizard, go to More actions and select this option. The wizard opens and allows you to browse and register SQL Server instances.
Remove
If you no longer want to manage an instance, you can remove it by selecting the respective instance, going to More Actions on the action items bar, and selecting Remove. You can also find this option by clicking the gear icon next to the instance. SQL Inventory Manager displays all removed instances on the Ignored instances view. For more information about removing instances click here.
Add SQL Server instance
If you want to access the Add SQL Server instance wizard, go to More actions and select this option. The wizard opens and allows you to browse and register SQL Server instances.
Core Factor Table
If your instance is using SQL Server core licensing, you can view the current Core Factor Table values by selecting the appropriate instance, and then clicking Core Factor Table. These values are set by Microsoft and can help you calculate the number of possible core licenses for your physical servers. for more information about this feature, see Using the Core Factor Table.
...
- # of Sockets. Displays the number of cores per processor, whether physical or virtual.
- # 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 the Core Factor Table, this number is provided by Microsoft based on the CPU in use.
- Possible Core Licenses. Displays the product of the total number of cores on a system multiplied by the Core Factor.
- Fully Licensed with SA. Check this box to remove the license count for the instance. You can also manage this setting in the Edit MS SQL Server License Information dialog box.
- Last Changed. Displays a timestamp of the most recent change to this record. Changed values include SQL Server major version, CPU name, number of processors, and total number of cores.
...
If you select several instances SQL Inventory Manager allows you to perform the following bulk actions on the selected instances:
...
For example, if you have a new DBA, you can select all instances on this tab and click Edit Owner to change all instances owner at once.
Options available for multiple instances
To bulk edit several instances, select the instances you want to change and follow any of these paths:
- Click the option you want to perform on the action items bar: Edit Owner, Edit Location, Edit Credentials, Edit Tags, Export, Disable Monitoring, Decommission, Remove, Add SQL Server Instance, and Core Factor Table.
- Or click the gear icon next to one of the selected instances. SQL Inventory Manager opens a dialog window that shows you on how many instances you are performing the changes.
...