Access the System Performance landing page by clicking Designer Studio >System > Performance. The following tabs are available:
Use this tab to understand the system resources consumed by processing 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 tab — 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 tab — Full Details Display.
Click:
NaN
indicates that a statistic was not available.)Pega Platform 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.
You can monitor the interactions between the Pega Platform 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.
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.
This tab is available only to users who hold the Code-Pega-.PerformanceTool privilege.
Before starting the Database Trace tool, click the Trace Options button and complete the options form. See Database Trace options. Select only the minimal set of options that are required to aid your debugging. Click OK, then click Close.
Click the Start icon to start the Database Trace tool. Perform the operations that you want to trace. Click the Stop icon 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. |
Actions |
Save icon - click to download a local text file that can be interpreted in Excel Delete icon - click to remove the row (recorded data for the thread) |
An alternative approach that provides comprehensive tracing of SQL statements sent to the PegaRULES database is the dumpStats
parameter in the prconfig.xml file.
To enable this feature:
As an alternative to updating the prconfig.xml file, you can use Dynamic System Settings to configure your application. See Dynamic System Settings data instances.
This setting generates a system-wide database trace file in the ServiceExport
directory that can become very large quickly, and can affect system performance. Use this setting only for brief periods, and when a single-requestor DB trace is not suitable.
Use this tab to obtain a detailed trace of performance information about the execution of activities, when condition rules, and data transforms 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 tab provides more performance details than the Tracer tool. When enabled, the Profiler 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 landing page tab.
This tab launches a utility that searches for rules in your application that are using page lists where they could instead use lightweight lists for better performance. See Rules not using lightweight lists utility.