Back Forward Performance tool — Interpreting DB Trace Results

C-1261 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. VAGUE

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 ONLY INSERTS?

Cache Access

Hit and miss statistics for the rule cache.

DB Trace Data

Unprocessed data as captured by the DB Trace facility

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

Definitionsrule cache, Storage Stream

Related topicsWorking with the PegaRULES database

UpAbout the Performance tool