Regresar
-
Título
Creating custom User-defined Database Groups -
Descripción
While all existing and newly discovered instances are added to the All list, the Databases area of the navigation pane allows creating, editing, and removing sub-groups of database instances, by that means serving as a filter that allows displaying only a specific, user-defined group of instances.The Databases area includes the following components, which can be selected from a drop-down list:- Database Groups — includes by default the All list, and the Database Groups list, which serves as the parent group for creating user-defined sub-groups of database instances. Such sub-groups are recognized as Foglight services.The Database Groups section also displays the highest severity level of the database groups, under the column Sev.
- Services — displays the configured services, which contain at least one object (database topology) that y Foglight for SQL Server uses.
All the Foglight for SQL Server sub-groups, which were created using the Database Groups section, are displayed also under Services. In addition, Services displays groupings of monitored resources that were created using the Service Builder dashboard, and contain Foglight for SQL Server database topology.
The Services section also contains the column SLC (Service Level Compliance), which indicates the current availability of the selected service over a given period. For details about the Service Builder dashboard, see the Foglight Online Help.
-
Resolución
The following video details how to create a custom user defined group of databases.
To create a database group:
- In Foglight 6.0 and higher, navigate to the Databases dashboard and click the collapsing arrow next to All in the top left corner of the panel
- Select the parent database instance group, Database Groups, under Databases in the navigation pane.
- Click the + button (icon).
The Add Sub Group dialog box appears. - Type a name for the group in the Name field.
- Type a description for the group (optional).
- Select an instance in the Available column, and click [>] to move the instance to the Selected column.
Alternatively, click [>>] to move all the databases to the Selected column. - Click OK.
The sub-group name appears in the Database Groups list.
The database instances are listed in the Databases dashboard.
After adding one or more user-defined sub-groups, it is possible to add sub-groups to these sub-groups.
To add sub-groups to a selected group:
- Position the cursor on the requested group’s name.
- Repeat Step 2 to Step 6 from above.
* NOTE: The Add Group dialog box displays the name of the parent group in the Parent field. Before proceeding, ensure that the sub-group is added to the requested group.To remove a database sub-group:
- Select the sub group to remove.
- Click the X button (icon).
The verification dialog box appears. - Click Remove.
The sub-group is removed from the Database Groups list.
To edit a database sub-group:
- Select the requested sub group.
- Click the pencil button (icon).
The Edit Group dialog box appears. - To add an instance to the sub group, select the requested instance in the Available column and click [>].
The selected instance moves to the Selected column. - To remove an instance from the sub-group, select the requested instance in the Selected column, and click [The selected instance moves to the Available column.
- Click OK.
