Database Management

DPA Web Console slowness

This article provides information about DPA web console being sluggish on how to enable debug and some workaround

First published date

11/1/2018 1:31 PM

Last published date

12/17/2021 2:58 AM

Overview

This article provides information about DPA web console being sluggish on how to enable debug and some workaround

Product section

Database Performance Analyzer

Resolution

Enabling Debug for Support 

  1. Clear the chart cache by clicking Options > Support > Clear Chart Cache.
  2. In the address bar, use the setLogger method to enable debugging. After /iwc type the following:

    /setLogger.iwc?component=charts&level=debug

    For example:

    http://host:port/iwc/setLogger.iwc?component=charts&level=debug

  3. Return to the DPA interface and click the SQL, Waits, and other tabs and areas that are slow.
  4. Disable debugging in the address bar. After the /iwc type the following: 
    /setLogger.iwc?component=charts&level=info

    For example:

    https://<DPAserver>:8124/iwc/setLogger.iwc?component=charts&level=debug

  5. Click Options > Support.
  6. Under Downloads, click Download All Log Files (Zipped).
  7. Save and attach the .zip file to a support ticket .


Alternatively, we can try workaround steps

1. Go to DPA installation path (C:\Program Files\SolarWinds\DPA\iwc\tomcat\webapps\iwc\WEB-INF\classes\spring\)
2. Find the file 'ehcache.xml'
3. Copy the original and paste it to your desktop (For Backup purposes)
4. Edit the ehcache.xml
5. Find 'getMetricsIDCache'
6. Increase the heap size from 10000 to 100000

Before
<heap>10000</heap>
After 
<heap>100000</heap>

7. Save the file
8. Restart the DPA Service (Ignite PI)