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 |
Cache Access |
Hit and miss statistics for the rule cache. |
DB Trace Data |
Unprocessed data as captured by the DB Trace facility |