Performance tool — Interpreting DB Trace Results

The DB Trace feature produces a text file containing the SQL statements, rule cache hit statistics, timings, and other data that reflect your requestor session's interactions with the PegaRULES database or other relational databases.

1. Click the Stop DB Trace link to end tracing and close the text file.

2. Click Download or Display DB Trace to save the text file on your workstation or a shared drive.

3. Click Start Excel to open an Excel worksheet that incorporates macros from Pegasystems Inc.

4. Within Excel, click Get Data and Create Views. Open the text file. Excel automatically applies a macro to load, analyze, and format the data. (This may take several seconds depending on file size.)

Four views are available. Use standard Excel controls including pivot tables to explore the data.

Excel tab	Description
Interaction Summary	Average duration (in seconds) and counts for each checked operation, grouped by interaction number. (The first interaction after you sign on is numbered 1).
SQL calls	SQL INSERT statements performed
Cache Access	Hit and miss statistics for the rule cache.
DB Trace Data	Unprocessed data as captured by the DB Trace facility

For advanced suggestions on avoiding resource-intensive operations with the PegaRULES database, see Writing SQL, a PDF document available on the Pega Developer Network.

rule cache, Storage Stream

Working with the PegaRULES database

About the Performance tool