The lnventory->Instances screen is used to display a list of all Instances that have been set up in the WISdom collection environment. Instance information is displayed in a table format with sortable columns in the Database Instances section.
The display can be filtered by using the drop-down menus for Host, Instance, Platform, Edition, Monitoring, Data Collector, and Tag. These filters relate to the columns in the table of the Database Instances section.
The Search area (magnifying glass in the upper right corner of the screen) provides the ability to search for a string or name, further limiting the Instances displayed in the Database Instances table.
Database Instances
Displays a table with sortable columns for the Health, Silencing, Host, Instance, Last Restart Time, Annual Compute Cost, Databases, Database Size, Memory Usage, Logical Cores, CPU Usage (Core), and Tags for all monitored Instances.
- The Health column displays the current monitoring status of the Instance with a red or a green dot.
- Green represents Healthy monitoring, no errors.
- Red represents Not Healthy monitoring, check the Collector Health screen for more information.
- The Silencing column displays whether a current or future alert Silencing Window has been configured.
- Multiple Silencing windows may be configured, but not indicated here.
- The Host column displays the name of the Host.
- This name is popluated when an Instance has been added and the collector retrieves the @@ServerName from the SQL Instance.
- The Instance column displays the instance name.
- The Last Restart Time displays the date/time stamp of the last restart of SQL Server.
- The restart time is determined by the created date of the TempDB
- The Annual Compute Cost column displays the estimated or customized cost associated with the Host in dollars.
- The Databases column displays the count of databases on that instance.
- The Database Size column displays the total size allocated to all databases on the instance.
- The Memory Usage column displays the memory allocated to the instance.
- The Logical Cores column displays the number of logical cores available to the instance.
- The CPU Usage (Core) column displays the average CPU utilization attributed to the instance.
- The Tags column displays the Tags associated with the instance.
Assign Value / Edit
Limited editing is available for instances, the primary editing related to an instance's information will be done in the Collections - Resources section of the Admin Console screen.
To edit a single instance, click the Three-Dot icon at the end of the row and choose the Edit button. A flyout will appear with the option to edit the Tag(s) associated with the instance. To edit Tags for more than one host at a time, check the boxes in the leftmost column, then click the Assign Value button at the top-right.
When an instance is selected via the check box at the beginning of the row, the Migrate button becomes operational. When clicking the button, the servers checked will be prepopluated but may be modified when the Migration Recommendations pop up displays. See the Migration page of the User Guide for more details.