Interpreting Database Tracer results

The Database Tracer gadget 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 red square to end tracing and close the text file.

2. Click the download icon 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.) If prompted by an Excel security warning, you need to enable this macro.

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

rule cache, Storage Stream

Working with the PegaRULES database

System category — Performance landing page