Skip to main content

Generating a system-wide database trace

Suggest edit Updated on May 11, 2022

As an alternative to using the Database Trace tool, you can trace system-wide database statistics. As a best practice, do this for very short periods on a non-production system.

Caution: 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.

To enable a system-side database trace, do either of the following steps.

  1. Update the prconfig.xml file and restart the server.
    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.
  2. As an alternative to updating the prconfig.xml file, you can use dynamic system settings to configure your application. See Configuring dynamic system settings.
What to do next: Turn off system-wide database trace by setting the dumpStats setting to false.
Did you find this content helpful? YesNo

Have a question? Get answers now.

Visit the Support Center to ask questions, engage in discussions, share ideas, and help others.

We'd prefer it if you saw us at our best.

Pega.com is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us