Table of Contents Previous Next


4 Performance Monitoring and Management : 4.5 Alerting : 4.5.2 Using the Manage Alerts Tab

Use the PEM Client's Manage Alerts tab to define, copy, or manage alerts. To open the Manage Alerts tab (shown in Figure 4.33), select Manage Alerts from the Management menu.
Use the Quick Links toolbar to open dialogs and tabs that will assist you when managing alerts:
Click Copy Alerts to open the Copy Alert Configuration dialog and copy an alert definition.
Click Alert Templates to open the Alert Template tab, and modify or create an alert template.
Click Email Groups to open the Email Groups tab, and modify or create an email group.
Click Server Configurations to open the Server configuration dialog and review or modify server configuration settings.
Use the table in the Alerts section of the Manage Alerts tab to create new alerts or manage existing alerts.
You can use the Alert Templates tab (shown in Figure 4.34) to define a custom alert template or view the definitions of existing alert templates. To open the Alert Templates tab, select the Manage Alerts... menu option from the Management menu. When the Manage Alerts tab opens, select Alert Templates from the Quick Links toolbar.
Use the Show System Template drop-down listbox to filter the alert templates that are displayed in the Alert Templates table. Use the listbox to select a level of the PEM hierarchy to view all of the templates for the selected level.
To define a new alert template, use the Show System Template drop-down listbox to select None, and click the Add icon (+) located in the upper-right corner of the alert template table. The alert template editor opens as shown in Figure 4.35.
Use fields on the General tab to specify general information about the template:
Use the Template name field to specify a name for the new alert template.
Use the Description field to provide a description of the alert template.
Use the Target type drop-down listbox to select the type of object that will be the focus of the alert.
Use the Applies to server drop-down listbox to specify the server type (EDB Postgres Advanced Server or PostgreSQL) to which the alert will be applied; you can specify a single server type, or ALL.
Use the History retention field to specify the number of days that the result of the alert execution will be stored on the PEM server.
Use the Threshold unit field to specify the unit type of the threshold value.
Use fields in the Auto create box to indicate if PEM should use the template to generate an automatic alert. If enabled, PEM will automatically create an alert when a new server or agent (as specified by the Target type drop-down listbox) is added, and delete that alert when the target object is dropped.
o
Move the Auto create? slider to Yes to indicate that PEM should automatically create alerts based on the template. If you modify an existing alert template, changing the Auto create? slider from No to Yes, PEM will create alerts on the existing agents and servers. Please note that if you change the slider from Yes to No, the default threshold values in existing alerts will be erased, and cannot be recovered.
o
Use the Operator drop-down listbox to select the operator that PEM will use when evaluating the current system values.
Use the Check frequency field to specify the default number of minutes between alert executions. This value specifies how often the server will invoke the SQL code specified in the definition and compare the result to the threshold value specified in the template.
Use the fields on the Probe Dependency tab (see Figure 4.36) to specify the names of probes referred to in the SQL query specified on the SQL tab:
Use the Probes drop-down listbox to select from a list of the available probes; highlight a probe name, and click the Add button to add the probe to the list of probes used by the alert template. To remove a probe from the selected probes list, highlight the probe name, and click the Delete icon.
Use fields on the Parameters tab (see Figure 4.37) to define the parameters that will be used in the SQL code specified on the SQL tab. Click the Add icon (+) and:
Use the Name field to specify the parameter name.
Use the Data type drop-down listbox to specify the type of parameter.
Use the Unit field to specify the type of unit specified by the parameter.
Use the Code field on the SQL tab (shown in Figure 4.38) to provide the text of the SQL query that the server will invoke when executing the alert. The SQL query will provide the result against which the threshold value is compared; if the alert result deviates from the specified threshold value, an alert will be raised.
Within the query, parameters defined on the Parameters tab should be referenced sequentially by the variable param_x, where x indicates the position of the parameter definition within the parameter list. For example, param_1 refers to the first parameter in the parameter list, param_2 refers to the second parameter in the parameter list, and so on.
Use the Detailed Information SQL field to provide a SQL query that will be invoked if the alert is triggered. The result set of the query may be displayed as part of the detailed alert information on the Alerts dashboard or Global Overview dashboard.
Click the Save icon to save the alert template definition and add the template name to the Alert Templates list. After saving a custom alert template, you can use the Alerting dialog to define an alert based on the template.
To view the definition of an existing template (including PEM pre-defined alert templates), use the Show System Template drop-down listbox to select the type of object monitored. When you select the object type, the Alert Templates table will display the currently defined alert templates that correspond with that object type.
Highlight a Template Name in the list, and click the Edit icon (at the left end of the row) to review the template definition.
Use the tabs on the Alert Templates dialog to view detailed information about the alert template:
To delete an alert template, highlight the template name in the alert templates table, and click the Delete icon. The alert history will persist for the length of time specified in the History Retention field in the template definition.

4 Performance Monitoring and Management : 4.5 Alerting : 4.5.2 Using the Manage Alerts Tab

Table of Contents Previous Next