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.


Trace Magic requires Version 4 of the Microsoft 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:
  •     Windows XP (32-bit)
  •     Windows 7 (32-bit)
  •     Windows 7 (64-bit)

Other platforms may or may not function correctly with TraceMagic. Platforms that will not run the Microsoft framework will not
likely run TraceMagic.

Download link - Login Required.



  1. Anonymous said,

    I'm the author of TraceMagic and wanted to thank you for your post & also let you know we released a new version of the tool last week that's significantly enhanced - with over 70 bug-fixes and new features, it's something worth checking out if you're a TM user. Your links and other information are still valid.

    on July 8, 2013 at 2:12 PM  

  2. Unknown said,

    Hi im eva peoplesoft consultant. I was just browsing blogs there I found your blog is interesting.. thanks for posting… keep on posting mypeoplesoft

    on September 6, 2013 at 8:18 AM