ManageEngine® SQLDBManager Plus

New SQL Group

<< Prev


Next >>


Creating New SQL Group


This section deals with how to a create new SQL Group. The SQL Group is compartively different from Sub Group in terms of information displayed about critical SQL servers. Through SQL Group, SQLDBManager Plus instantly displays availability and health snapshot. Once you create a SQL Group, you can view the health of the Sub Groups and know how each individual Sub Group is performing. If there is a problem in the SQL Group, you can drill down and identify which component is having a problem.


You can also configure dependencies and powerful alarm rules for intelligent alert correlation. To create such as a SQL Group, follow the steps below:

  1. Click New Monitor Group and select SQL Group from the drop-down menu.

  2. Provide a Name for the Monitor Group. This is mandatory and only alphanumeric characters, dashes (-), underscores (_), periods (.), and spaces ( ) are allowed.

  3. Provide a Description, if required.

  4. Select the Owner from the list of users displayed.

    Operator if associated as an owner will have Read Only Access to that particular Monitor Group alone.
    Admin user is a super user and will be able to see all Monitor Groups.
    Manager if associated will be able to view this Monitor Group in Manager Console. Using this option, Restricted Monitor Groups alone can be shown in Manager Console. [By default, if the Manager is not explicitly associated to a Monitor Group, the Manager will be able to access all the Monitor Groups in the Manager Console]

  5. Select SQL Group as the group type.

  6. Select theDatabase from the options displayed. The components available are End User Transaction (URL) group, Network devices group, Edge Devices group, Web Server Group, Application Server Group, SQL Group and Server Group. The components that you select will be automatically added as sub groups within the SQL Group.

  7. Select the Location for associating the monitor group to World Map Business View under Advanced section. Otherwise, click the 'Add Location' link and select custom locations from the google map that opens up.

  8. Click Create Monitor Group button to create the SQL Group. You can add monitors any time using the Associate Monitors option.

Note: You can convert a SQL Group to a monitor group or vice versa by changing the Group Type. Click Monitor Group Options link from the SQL Group page and select the Edit option. This will take you to the Modify Monitor Group section. You can modify the Group Type values from this screen.

Creating a Sub-Group within a SQL Group

If you have selected 'Application Components' while creating the web application group, the sub groups will be automatically created based on the options you have selected. You can also add sub groups later on by following the steps given below.

Note: You can create up to six levels of sub groups for a SQL Group, by default.

<< Prev


Next >>

Bulk Configuration

Performance Polling