PeopleSoft practices will showcase entire knowledge value and tips to use and configure PeopleSoft ERP – sharing knowledge from experienced consultants and ERP experts
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:
Peoplesoft Practices
135 members
Description
PeopleSoft practices will showcase entire knowledge value and tips to use and configure PeopleSoft ERP – sharing knowledge from experienced consultants and ERP experts
TraceMagic: Utility for analyzing *.tracesql trace files
by Philip Calvert
Nov 20, 2013
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.
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
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:
Read Further: http://peoplesoftlearnings.blogspot.com/2012/08/tracemagic-utility-...