DWP Performance Analysis (Extension)
Overview
The DWP Performance Analysis Extension is a simple application that helps analyze the workload of the Enterprise Service Management application during one or more days, and see the periods when the Application was on high load, as well as the information that could be a reason for the performance peaks – the moments when the average time required for processing the web request is unusually high and the end-users start feeling delays while working with the application. Also, the tool is very helpful in analyzing the impact of different changes in Application on overall performance.
Principle
The tool uses the data kept in IIS logging files to analyze all the web requests received by the application and the time required by the application to process these requests. The time spots when request processing time rockets the interactive users start feeling delays while working with the Application. Such time intervals are referenced as Performance Peaks and need to be deeply analyzed.
Prerequisites
Digital Workspace Platform v. 11.0.2 or greater preinstalled.
Installing the Extension
Install the DWP Performance Analysis Extension from the Extension Gallery:
After successful installation, the following areas are available in Administration Application
- Reports → Performance Analysis area
- User Interface → Data Queries → Analyze Performance Action
DWP Performance Analysis
The Extension automatically detects all required resources for the analysis, like all required IIS log files as well as the connection string to the Production database.
The resulting report contains charts which represent different aspects of the Application Performance, among them:
- Web Requests Analysis (UTC)
- Top 10 Longest Running Requests
- Top 10 Average Longest Running Requests
Web Requests Analysis
The chart represents the average time taken by the Application to process the Requests within a specified time interval (setting Interval in minutes). When the Average Request time exceeds 1 second (1000 ms) the end-user feels latencies in working with the application. Therefore the time intervals are very good candidates for deeper research.
Only requests that match the filtering criteria, like setting Date, Interval, and Time range are considered.
The chart also utilizes data about the amount of the Requests within the time interval. Having the Request number on the chart allows easily identify how the application is used, and how increasing the amount of the Application concurrent interactive users affects the overall Application Performance.
Using the chart Filters (Date, Interval, and Time range) you can bring the other data to the chart. The data is split into Time ranges to allow a better view of performance peaks.
Click on the chart data for more details and Top 10 Requests for the selected time Interval, for instance:
- Top 10 Longest Running Requests: This area displays the top 10 requests per day which have the longest execution time.
- Top 10 Average Longest Running Requests: This area displays the top 10 Requests per day which took the largest average time ("all requests time taken" / "requests count") for processing.
Click on the request to see more details. If the request can be identified and is not just a Web Operation, you will see the Dataset View and the corresponding Data Query that takes too much time to run. Such Data Queries can be examined with the Analyze Performance action.
Data Queries Performance Analysis
The Analyze Performance Action allows analyzing a specific Data Query's performance and takes into account additional parameters for the Query, such as a particular User from the system and additional Filters.
The Action is available from the Performance Analysis Report, as described above, and is also present in the Administration application → User Interface → Data Queries.
Click on the necessary Query, open more actions, and run Analyze Query:
Specify the suggested options:
- Run as: specify the user from the system to run the query with the permissions of the specified user
- Filters: select from one or more Data Query filters available in the system
When necessary parameters were specified, click Analyze Performance:
The action is running in the background and executing this Data Query with different conditions trying to identify some issues with the Data Query definition.
The result of the analysis and possible suggestions on how to improve the performance of the overall Data Query and specific columns might look as follows:
Uninstallation
To uninstall the extension run the Uninstall Package action. For more details, see also. Configuration Package Uninstallation page.