Instances

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 Monitoring, Edition, and Data Collector. These filter relate to the columns in the table of the Hosts 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 Instance Name, Host Name, Data Collector the instance has been assigned, the Time Zone configured for the Instance, type of WISdom Monitoring, Environment, Tier of Service, Database Platform, and the Last SQL Restart Time 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 Instance column displays the instance name.
• • 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
• Data Collector displays the name of the data collector the instance has been assigned for collection
• The Time Zone columns displays selected Time Zone that corresponds to User requirements, preferences, or work locations. The dashboard displays will reflect the selected Time Zone.
• The Monitoring column displays the level of monitoring in effect.
• The Environment column displays the Environment configured at setup where the server resides.
• The Tier of Service column displays the Service Tier configured at setup.
• The Database Platform column displays the type of database engine (SQL Server, Oracle, or MySQL) of the Instance
• The Last SQL 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

Adding and Managing Instances

To edit a single Host, click the Three-Dot icon at the end of the row and choose the Edit option in the pop up. A flyout will appear with the option to edit the Name and/or the Monitoring.
The Bulk Edit may be used to edit more than one Host, only the Monitoring is available for editing.

Adding an Instance

To add an Instance, click the [+] Add Instance icon on the card tool bar. The Add Instance flyout will be displayed.
Use the drop-down menus to specify the Platform, Collection Environment, Credentials, Monitoring, Tier of Service, and Environment for the additional instance. All the fields are required.
The Collection Environment references the Collector Name the Instance(s) will be assigned to. Some environments may have more than one (1) collector (multiple choices will be displayed in the drop-down).
The Credentials displayed in the drop-down are based on the Collection Environment chosen.

• Additional credentials for a collection service may be set up in the Admin Console to use to collect data on specified Instances.
• Administrator rights are required to add credentials in the Admin Console, see the Admin Console section for more information.
• If the service account does not have the permissions to collect the data on the target Instance, additional credentials would be created for a Collection Environment. (Examples: an Azure Managed Instance or Azure SQL Database, or if a target Instance is in an untrusted domain or a DMZ.)
  Use the Instance List box to add a multiple Instances to the chosen Collection Environment (list can be pasted).
• Click the Save button to add the instance(s) to WISdom.

Edit an Instance

To edit a specific, single Instance, click the Three-Dot icon at the far right of the row and select the Edit function. A flyout will be displayed with the Instance name. Update the fields, as necessary.

• If the Instance Name is updated, it will be treated as a new Instance. The new name will be added to the Instance list and the service will attempt to connect and collect data.

Bulk Editing Instances

To edit multiple Instances and update them with the same data, click the row checkbox for the instances to be edited.
Click the Bulk Edit icon in the upper right-hand corner of the table to display an editing flyout.

• Select the Tier of Service and/or Monitoring from the drop-down menus.
• Specify the RTO and/or RPO value by either typing number of minutes or using the UP/Down arrows.
• Click the Save button to save the modifications.

Remove an Instance

To remove an Instance, click the Three-dot icon at the far right of the row and select the Delete function from the pop-up. A message warning that Instance deletions are permanent and cannot be undone is displayed.

• Click Delete Instance to delete the Instance. Deleting an Instance removes all the Instance data from the backend database and cannot be undone.
• Click Cancel to exit without deleting an Instance.
• Only a single Instance may be deleted at a time (even in Bulk mode).