This article explains explain how to group servers with similar properties to allows displaying an overview of the servers in the group, filtering alerts by the group, and configuring alert or measurements settings for all servers in the same group at once
Monitored servers can be grouped together to allow applying the same alert configuration settings to them more easily. Additionally, the grouping capability helps group servers based on the business process supported and facilitates the prioritization of alarms
Q: How can I create a server group?
- Go to the SQL Server instances pane
Right click anywhere in the pane and click Server grouping from the context menu
The Server grouping dialog is open now
- Click on Add group to create a new server group
Double click on the created group to enter the name. Press Enter
Q: How can I add servers to a group?
A: To add servers to a group, drag and drop each one in turn onto the group name. Dragging multiple selected servers is not possible
Right click on the server and select Move to group, and then the group from the submenu where the server will be moved
Q: How can I create a group hierarchy?
A: ApexSQL Monitor allows you to move one server group into another. If additional customization of existing servers is required, organizing the hierarchy with subgroups is advisable. For example if a production environment consist of multiple servers spread in different regions or countries, then servers from the same region or country can be organized in a subgroups
To do this:
- Create a group for each country and/or region
- Drag and drop those groups into a main group
Drag and drop servers into a new subgroups
To create the new group directly within the target group, select the target group and click Add group. The new group will be created directly as the subgroup of the target group
Q: What happens to the servers, within a group, when the group is deleted?
A: After deleting a group all servers that are the part of the removed group will be automatically moved in the parent group
Q: What are the advantages of using server groups?
A: One advantage is that by selecting the existing group in the SQL Server instances pane, the dashboard will display the information only for the servers that belong to the selected group. Also, metrics and alerts can be viewed and configured for each group separately.