Organizing monitored servers into groups

Applies to
ApexSQL Monitor

Summary

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

Description

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?
    A:

    1. Go to the SQL Server instances pane
    2. Right click anywhere in the pane and click Server grouping from the context menu

    3. The Server grouping dialog is open now

    4. Click on Add group to create a new server group
    5. 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

    Quick tip icon

    Quick tip:

    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:

    1. Create a group for each country and/or region
    2. Drag and drop those groups into a main group
    3. Drag and drop servers into a new subgroups

    Quick tip icon

    Quick tip:

    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.