Table of Contents Previous Next



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 4.21), select the Manage Custom Probes… icon from the Manage Probes tab.
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.
Use the fields on the General tab (see Figure 4.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.
Use the Columns tab (see Figure 4.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.
Use the Code tab (see Figure 4.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.
Use the Alternate Code tab (see Figure 4.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.


Table of Contents Previous Next