Identify database Connection issues

The Connection details page enables you to identify suspect connections that are leaking. To access the Connection details page, you must have an administrator license and the "Server Tools: Execute admin tools" access grant.

To enable this feature, set the ENABLE_CONNECTION_CORRELATION server configuration parameter to true.

To access the Connection details page:

  1. Log on to PPM.

  2. From the menu bar, select Open > Administration > View connection correlation.

The table on the left portion of the page displays the stack trace for each connection recorded when the connection was acquired from the pool.

To display the stack trace associated with the connection at the time it was acquired, click the corresponding connection entry.

Note: Because this feature involves some database overhead, we recommend that you use it only to troubleshoot connection leak issues.