System category — Performance page
PAL, Database Trace, and Performance Profiler gadgets

Access

Category	Page
System	Performance

Usage

Use the Performance page to access the Performance tool (PAL), the Database Trace gadget, and the Performance Profiler gadget.

PAL Performance tool

Use the Performance tool to understand the system resources consumed by processing of a single requestor session, or the SQL statements sent to the PegaRULES database by the requestor session.

You can interact with the summary page to record statistics. See Performance tool — Using the Summary display. Click the INIT, FULL, or DELTA links to access the Full Details display for that row. This display provides additional statistics from the same snapshot.

See Performance tool — Full Details Display.

Click:

• Add Reading — A new row of summary performance data appears. Statistics include input/output, elapsed time in seconds for certain processing, cache performance, locking, and server CPU demand, for the most recent interaction. Optionally, first click elsewhere in the portal window and perform one or several interactions that cause the performance you want to measure. The system retains extensive data for each interaction.
• Add Reading with Clipboard Size — A new row of summary performance data appears, including the size of the clipboard in bytes. Similar to Add Reading, but may add potentially costly processing.
• Reset Data — Initializes all counts and totals to zero.
• Save Data — Lets you save more than 100 statistics and values from each row into a Comma-Separated-Values file (CSV file type) for analysis with Microsoft Excel or other facilities. Column headings correspond to properties in the Code-Pega-PAL class, as presented on the Full Details display. (The value NaN indicates that a statistic was not available.)

Process Commander always accumulates cumulative resource statistics for the Performance tool. Use the landing page to display these statistics, and to identify incremental resources (in the delta rows) consumed by your processing. Because this feature displays existing data, its use does not degrade processing.

Database Trace tool

C-1261 You can monitor the interactions between Process Commander's server engine and the PegaRULES database or external relational databases, and the operation of the rule cache. Familiarity with SQL is required to interpret the output. B-21286

Operating this tool can adversely affect performance, and can produce a large volume of output. Use this tool only in appropriate non-production debugging environments, for short periods.

Before starting the Database Trace tool, click the Trace Options button and complete the options form. See Setting DB Trace options. Select only the minimal set of options that are required to aid your debugging. Click OK , then click Close.

Click to start the Database Trace tool. Perform the operations that you want to trace. Click the red square to stop the tool. Trace details appear in the table, summarized by Thread.

Field	Description
User	Operator ID.
Thread	Name of the Thread that generated this row.
Started	Date and time that database tracing started.
Stopped	Date and time that database tracing stopped.
Recorded Time	Elapsed time between start time and stop time.

Click the Save Icon at the right of each row to save the extensive trace details from that Thread to a local text file. Click Start Excel if you want to upload the saved text file and parse the text values into an Excel spreadsheet. After Excel starts, click Get Data and Create Views to import and process the saved file. See Interpreting DB Trace Results.

Performance Profiler gadget

Use the Performance Profiler gadget to obtain a detailed trace of performance information about the execution of activities, when condition rules, and model rules executed by your requestor session. The Profiler traces every execution (in all Threads) of rules of these three types in all RuleSets. Trace records are saved as instances of the Log-Trace-Profiler class.

This gadget provides more performance details than the Tracer tool or the Performance tool. However, when enabled this tool produces extensive output and requires substantial processing overhead. Disable this tool as soon as your data collection is complete.

For instructions see About the Performance Profiler gadget.

landing page

Designer Studio — Landing Pages

Help Home