Troubleshooting database requests

The Pega Platform database performance is a major factor in overall system performance, affecting response time for interactive, browser-based users, turnaround time for services, and throughput. You can use tools provided by Pega Platform to help you debug, trace, and analyze requests from the server to the Pega Platform database.

You can do the following:

  • Use the Clipboard tool to view the pyReportContentPage page. It shows the pxSQLStatementPre and pxSQLStatementPost properties that contain the SQL statement that ran. These values are available after your run a report definition rule. The pxResultCount property shows the number of rows returned. Use the Clipboard tool to view these values.
  • Use the Detail window of the Performance tool to view statistics for each user interaction since sign-on. For example, you can see the elapsed time (in seconds) that this user spent retrieving non-rule-resolved instances from the database.
  • Use the Database Trace facility, accessed from the Performance tool Summary display, to create a trace of all database requests from your session.
  • Generate a complete trace of all database requests by enabling the database/dumpStats entry in the prconfig.xml file or dynamic system settings.
  • Use the Alert log to can find those database operations that required an unusually long time to process.