Using the Profiler dashboard

You can use the Profiler dashboard to identify performance issues within the WFM application.

  1. In WFM, select Maintenance > System Administration > Diagnostic Tools > System Metrics.
  2. Click Profiler.
  3. Specify this information:
    Label
    Specify the name of the label. This is a required field.
    Time
    Select whether 5, 15, or 30 minutes or 1, 2, 4, or 12 hours. The profiler will run for the duration specified by default.
  4. Click Start to verify that the profiler is in progress.

    When you click the Start button, the Stop button and Refresh icon are displayed along with additional information below. Clicking the Stop button makes it not available for further interaction. The system then updates the actual time the profiling ran.

    For example, if you select a duration of five minutes but stop the profiling early, the data refreshes to reflect the actual elapsed time.

  5. Specify this information:
    Period
    Specify or select the profiling period from the list. This is a required field.

    The Period DB lookup stores performance readings and provides details such as the label, the time taken (in seconds) to profile the readings, and the corresponding start and end times.

    Flat
    Select the check box to flatten all URLs, Services, Rules, Conditions, Groovy scripts, SQL, or tasks.

    When the check box is selected, all the invoked secondary methods are displayed in a single, flat view.

    Exclude
    Select the check box to filter detailed usages according to URL, Service, Rule, Condition, Groovy, SQL, or Task.
  6. Click Load to display the dashboard.
  7. Click the expand icon to show or hide the readings under each label in the dashboard.
    Hits
    Defines the number of times the query accessed the database.
    Total ms
    Total time taken to load the query, measured in milliseconds.
    Avg ms
    Average amount of time taken, measured in milliseconds, between the minimum and maximum values.
    Min ms
    Minimum amount of time taken to load the query.
    Max ms
    Maximum amount of time taken to load the query.
    Time range columns (10 ms to ≥10 s)
    These columns show the number of requests that fall within specific response time thresholds. Each heading represents the upper bound of a time range. For example, 10 ms or 25 ms., except for >=10s which captures all requests exceeding the final threshold.
  8. Sort the columns in the results to view the max time or number of queries.
    You can also expand and collapse the results and select each item to view Usages information.
  9. Click the download icon to get the results in .csv format.
  10. Click the trash icon to delete the results.