ManageEngine® SQLDBManager Plus
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:
Click New Monitor Group and select SQL Group from the drop-down menu.
Provide a Name for the Monitor Group. This is mandatory and only alphanumeric characters, dashes (-), underscores (_), periods (.), and spaces ( ) are allowed.
Provide a Description, if required.
Select the Owner from the list of users displayed.
Select SQL Group as the group type.
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.
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.
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.
Click the Monitor Group Actions —» New Sub-Group option inside the SQL Group Details page.
Provide the Sub-Group Name, Description and select the Owner from the list of users.
Select the Group Type from the dropdown box.
Select the Location for associating the sub group to from the drop-down box. You can also use the 'Add Location' option to specify custom locations from google map.
Click the Create Sub-Group button to create the sub group.
You can then associate the desired monitors to the Sub Group.
Note: You can create up to six levels of sub groups for a SQL Group, by default.