Question
2
Replies
293
Views
Posted: August 18, 2015
Last activity: August 19, 2015
Closed
Solved
Can we use DBTrace to trace activity of multiple requestors in production or UAT environment?
Need to trace the DB activity in production and UAT to identify some issues as they are not logged in the system logs and are hard to identify.
Need to understand if we Can we use DBTrace to trace activity of multiple requestors in production or UAT environment? Please advise.
The application is running on pega platform v6.1 SP2
You can do system wide db trace. Please see the link below.
https://pdn.pega.com/sites/pdn.pega.com/files/help_v718/procomhelpmain.htm#basics/v6portal/landingpages/system/performance.htm#Database_Trace_tab
Excerpt
System-wide database trace
An alternative approach that provides comprehensive tracing of SQL statements sent to the PegaRULES database is the
dumpStats
parameter in the prconfig.xml file.To enable this feature:
1. Update the <database> node of the prconfig.xml file to add this element:
<entry key="dumpStats" value="true" />
2. Stop and restart the application server.
Note: You can also use Dynamic System Settings to configure your application. See How to create or update a prconfig setting.
This setting generates a system-wide database trace file in the
ServiceExport
directory that can become very large quickly, and can affect system performance. Use this setting only for brief periods, and when a single-requestor DB trace is not suitable.