Table of Contents Previous Next


6 Performance Monitoring and Management : 6.4 Customizing Probes

A probe is a scheduled task that returns a set of performance metrics about a specific monitored object. A probe retrieves statistics from a monitored server, database, operating system or agent. You can use the Manage Probes tab (shown in Figure 6.13) to override the default configuration and customize the behavior of each probe.
To open the Manage Probes tab, select Manage Probes… from the Management menu. The Manage Probes tab opens in the PEM client (see Figure 6.20).
C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\285830a2\Screen Shot 2017-02-16 at 8.42.10 AM.png
The Manage Probes tab provides a set of Quick Links that you can use to create and manage probes:
Click the Manage Custom Probes icon to open the Custom Probes tab and create or modify a custom probe.
Click the Copy Probes icon to open the Copy Probe dialog, and copy the probe configurations from the currently selected object to one or more monitored objects.
Move the Default switch in the Execution Frequency columns to N to enable the Minutes and Seconds selectors, and specify a non-default value for the length of time between executions of the probe.
Move the Default switch in the Enabled? column to No to change the state of the probe, and indicate if the probe is active or not active.
Please note: If data from a Disabled probe is used in a chart, the chart will display an information icon in the upper-left corner that allows you to enable the probe by clicking the provided link.
Move the Default switch in the Data Retention column to No to enable the Day(s) field and specify the number of days that information gathered by the probe is stored on the PEM server.
The Manage Probes tab may display information about probes that cannot be modified from the current node. If a probe cannot be modified from the current dialog, the switches are disabled. Generally, a disabled probe can be modified from a node that is higher in the hierarchy of the PEM client tree control; select another object in the tree control to modify which probes are displayed or enabled in the Manage Probes tab.
You can use the PEM Custom Probes tab to create a new probe or modify an existing user-defined probe. To open the Custom Probes tab (see Figure 6.21), select the Manage Custom Probes… icon from the Manage Probes tab.
C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\82088d10\Screen Shot 2016-11-14 at 4.50.07 AM.png
Use the Show System Probes? switch to display or conceal the system probes on the Custom Probes tab.
You can use the Custom Probes tab to create a new probe or modify an existing probe. To create a new probe, click the Add icon in the upper-right corner of the tab; provide a name for the new probe in the Probe Name column. Then, select the Edit icon (located to the left of the probe name) to review or add the probe definition.
C:\Users\susan\Desktop\custom_probes_general.png
Use the fields on the General tab (see Figure 6.22) to modify the definition of an existing probe or to specify the properties of a new probe:
Use the Probe Name field to provide a name for a new probe.
Use the Collection method field to specify the probe type. Use the drop-down listbox to select:
SQL - the probe will gather information via a SQL statement.
WMI - the probe will gather information via a Windows Management Instrumentation extension.
Batch - the probe will use a command-script or shell-script to gather information.
Before creating a batch probe on a Linux system, you must modify the agent.cfg file, setting the allow_batch_probes parameter equal to true and restart the PEM agent. The agent.cfg file is located in /opt/PEM/agent/etc.
On 64-bit Windows systems, agent settings are stored in the registry. Before creating a batch probe, modify the registry entry for the AllowBatchProbes registry entry and restart the PEM agent. PEM registry entries are located in HKEY_LOCAL_MACHINE\\Software\\Wow6432Node\\EnterpriseDB\\PEM\\agent.
Please note that batch probes are platform-specific. If you specify a collection method of Batch, you must specify a platform type in the Platform field.
Use the Target Type drop-down listbox to select the object type that the probe will monitor. Target type is disabled if Collection method is WMI.
Use the Minutes and Seconds selectors to specify how often the probe will collect data.
Use the Probe Enable? switch to specify if the probe in enabled by default. Specify Yes to enable the probe by default, or No to specify that the probe is disabled by default.
Use the Data Retention field to specify the number of days that gathered information will be retained in the probe's history table.
Use the switch next to Discard from history to specify if the server should create a history table for the probe. Select Yes to discard probe history, or No to retain the probe history in a table.
Use the Platform drop-down listbox to specify the type of platform that the probe will monitor. This field is enabled only when the Collection method is Batch.
C:\Users\susan\Desktop\custom_probes_columns.png
Use the Columns tab (see Figure 6.23) to define the columns in which the probe data will be stored. Navigate to the Columns tab, and click the Add button (in the upper-right corner) to define a new column. After a providing a column name in the Name field, click the Edit button (to the left of the new column name) to provide information about the column:
The Internal Name field is not enabled for user-defined probes.
Use the Column Type drop-down listbox to specify if the column is a Key column (a primary key) or a Non key column. Non-key columns are generally metric items (values that can be graphed).
Use the Data Type drop-down listbox to specify the type of data that will be stored in the column.
Use the Unit field to specify the unit of measure that applies to the metric stored in the column. This unit is displayed on the Y-Axis of a custom chart or a Capacity Manager chart. This is an optional field.
Use the Graphable switch to specify if the defined metric may be graphed, and that the probe should be accessible from the Capacity Manager or Manage Charts dialogs.
Use the Is PIT switch to specify if the metric should be stored by point-in-time.
Use the Calculate PIT switch to specify that the server should calculate a point-in-time value for the metric data. Calculate PIT is disabled if Is PIT is Yes.
C:\Users\susan\Desktop\custom_probes_code.png
Use the Code tab (see Figure 6.24) to specify the default code that will be executed by the probe:
If the probe is a SQL probe, you must specify the SQL SELECT statement invoked by the probe on the Code tab. The column names returned by the query must match the Internal Name specified on the Column tab. The number of columns returned by the query, as well as the column name, data type, etc. must match the information specified on the Columns tab.
If the probe is a batch probe, you must specify the shell or .bat script that will be invoked when the probe runs. The output of the script should be as follows:
The first line must contain the names of the columns provided on the Columns tab. Each column name should be separated by a tab (\t) character. From the second line onwards, each line should contain the data for each column, separated by a tab character.
If the probe is a WMI probe, you must specify the WMI query as a SELECT WMI query. The column name referenced in the SELECT statement should be same as the name of the corresponding column specified on the Column tab. The column names returned by the query must match the Internal Name specified on the Column tab. The number of columns returned by the query, as well as the column name, data type, etc. must match the information specified on the Columns tab.
C:\Users\susan\Desktop\custom_probes_alt_code.png
Use the Alternate Code tab (see Figure 6.25) to provide code that will be invoked if the probe fires on a specific version of the server. To provide version-specific code, move the Applies to any server version? switch to No, and click the Add button. Then, select a version with the Database Version(s) drop-down listbox; click the Edit button (to the left of the version name) to provide the code that will execute when the probe fires.
If you select a database version, and leave the Probe Code column blank, PEM will invoke the code specified on the Code tab when the probe executes on a server that matches that version.
When you've finished defining the probe, click the Save icon (in the corner of the Custom Probes tab) to save the definition, and make the probe data available for use on custom charts and graphs.
Use the Delete icon (located to the left of a Probe Name) to delete a user-defined probe. When you delete a probe, the probe is marked for deletion and will be deleted later (when custom probes are purged). During the deletion, the probe definition is deleted and any corresponding tables are dropped from the pemdata and pemhistory schemas.
C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\46758aeb\Screen Shot 2016-11-14 at 5.38.09 AM.png
C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\dd676f57\Screen Shot 2016-11-11 at 4.32.18 PM.png
You can use the Copy Probe Configuration… dialog to copy probe definitions from one monitored object to one or more monitored objects of the same type. To open the Copy Probe Configuration... dialog, highlight the object from which you are copying probes in the PEM client tree control, and select Manage Probes from the Management menu. When the Manage Probes tab opens, click on Copy Probe to open the Copy Probe Configuration dialog:
C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\682fe447\copy_probe_config.png
The dialog will copy the probe definitions from the object through which the Copy Probe Configuration dialog was opened, to the location(s) selected on the tree control (see Figure 6.28).
Note that if you specify a parent node in the Copy Probe Configuration tree control, PEM will copy the probe configurations to each object (of the same type) that resides under that node in the tree control. For example, to copy the probe definitions from one schema to all schemas that reside within a database, select only the parent database of the target schemas. Please note that a red warning symbol is displayed to the left of the name of a listed target object if that object is the source of the probe that is being copied.
When you have selected the target object or objects, click the Configure Probes button to copy the probe definitions to the location selected on the dialog.

6 Performance Monitoring and Management : 6.4 Customizing Probes

Table of Contents Previous Next