myPeopleSoft

PeopleSoft Community Network

TraceMagic: Utility for analyzing *.tracesql trace files

TraceMagic is a utility that gives PeopleSoft system administrators, programmers and support engineers the ability to quickly isolate performance bottlenecks in SQL Statements and/or PeopleCode functions. It accomplishes this by turning the text-based, time-ordered tracesql file into a sortable-grid display, allowing the user to quickly locate system performance issues.

TraceMagic is designed primarily to address the difficulty in working with tracesql files when attempting to
determine which SQL statement(s), and or PeopleCode programs are causing performance problems. As such, it tends to assume that certain trace flags were set during the creation of the trace file.

Requirements

Trace Magic requires Version 4 of the Microsoft dot.net Framework. The setup.exe program used to install TraceMagic on an end users machine will
inspect the target system for the presence of the prerequisite software, and request permission from the installer to download and install the
required software if needed. TraceMagic has been tested on the following platforms: