Help: Performance tool — Using the summary display

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

PRPC always accumulates cumulative resource statistics for the Performance tool. Use the tool 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.

Basics

Using this data, you can assess possible sources of improved performance (faster response time or higher throughput) through software changes, hardware changes, or rule changes.

As PRPC operates, it collects statistics about the demands made on processing resources, and the server system's response. The Performance tool summarizes and formats these statistics and presents them as HTML pages.

Performance data shows the processing demand statistics of your work since you connected, and may help you assess the performance impact between different approaches or configuration choices.

The DB Trace facility records SQL interactions between your PRPC session and the PegaRULES database.

Performance statistics can help you distinguish between performance issues that arise in the PRPC server, the PegaRULES database, or external systems called by the workflow. In all cases, the statistics can help you determine how to improve performance.

Using the links

Use these links at the top of the summary display:

Link	Effect
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. (Using the System Management Application (SMA), you can learn the size of each page. Start the SMA using > System > Tools > System Management Application, select a node, then click the Requestor Management menu item.) 5.5 GRP-372
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.)
Start DB Trace	Starts the DB Trace tool to trace PegaRULES database operations. See DB Trace Results.
DB Trace Options	See Setting DB Trace Options.
Start Profiler	Starts the Profiler to provide detailed CPU statistics for activity steps. When you select it, the link changes to Stop Profiler. Execute the activities or other rules to be profiled. Click the Stop Profiler link when you are finished. The resulting window lists a Profiler file for each Thread that you used, identified by your Requestor ID and Thread Name. Select a file for the Thread of interest to you and click Download or Display Data to send the CSV file to your workstation. Choose Open or Save in the Windows dialog box. Open the file with Microsoft Excel to review and analyze the data. You can also access this functionality using the Performance Profile tab on the Performance Profiler tab on the Performance landing page ( > System > Performance). For more information about the tab and a description of Profiler results, see About the Performance Profiler landing page tab.
Show Graph	Presents a bar chart highlighting major factors affecting performance. C-2656 5.2 See Interpreting the Performance Summary chart.
My Alerts	Provides additional detail on alerts from your own requestor session (or other filter criteria you provide). See Working with the My Alerts display. CODE-271 PROJ-505
Help	Displays this help topic.
PDN	Queries the PDN for the most recent articles regarding this tool. WWW access is required.

For each summary row, many more statistics are available on the full detail page. To see full details, click the Full or Init link on a row.

Understanding the basic statistics

The basic statistics display has three or four rows. On the initial display, statistics in the row labeled Full match those in the bottom row.

As you interact with PRPC, the statistics change to reflect the results of each interaction.

Columns of the display identify these counts and timings. The table below describes returned data. All CPU time is in milliseconds. The properties are stored in the PALPhase clipboard page, and are in the Code-Pega-PAL class.

The number of decimal places in timing results depends on the hardware and software in use. In general, the decimal values shown are significant. Measurement values are since log-in, or since the last Reset, or incremental between rows, depending on the row label.

Accessing the full details 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.

For a description of the contents of that window, see Performance tool — Full Details Display.

Technical note

When two instances of PRPC are installed on a single Windows server, some Performance tool statistics may not be available on the installation that is started second.

About the System Management application Performance tool — Full details display

Tools — System