Appeon 6.6 Prev Page Prev Page
Appeon Performance Tuning Guide
Appeon Performance
Expected performance level
Automatic performance boosting
Impact of the Internet and slow networks
Impact of “heavy” client-side logic
Impact of large data transmission
Performance-Related Settings
Appeon Developer performance settings
Appeon Enterprise Manager performance settings
Timeout settings
DataWindow data caching
Multi-thread download settings
Custom Libraries download settings
Log file settings
Internet Explorer performance settings
Web and application server performance settings
SAP Sybase EAServer
JVM startup option
Configuring data sources
HTTP properties
Microsoft IIS server
Recommendations for avoiding common errors on IIS
Advanced thread settings
Database performance settings
Recommended database driver
Recommended database setting
Identifying Performance Bottlenecks
Heavy window report
Appeon Performance Analyzer
Getting Started
Enabling Appeon Performance Analyzer
Starting Appeon Performance Analyzer
Getting to know Appeon Performance Analyzer
Removing Appeon Performance Analyzer
Working with Appeon Performance Analyzer
System Configuration
Calls Analysis
Download Analysis
View Detail
Additional Functions
Testing Appeon Web applications with LoadRunner
General Limitations on Performance Testing
Testing Environment
Testing Steps
Configuring AEM
Data Preparation (for update only)
Preparing Test Cases
Recording Scripts
Modifying Scripts
Additional steps for Update operation
Parameterization of SQL statements
Playing back Script to test the correctness of scripts
Setting Scenarios
Additional steps for Update operation
Running Scenarios
Modifying the scripts of NVO
Modifying the scripts of EJB/JavaBean
Errors appear when playing back scripts with LoadRunner 8.0
The value of sessionID is null
Error message appears in script playback
Error message in Appeon Log
Failed to parameterize scripts
Out of memory error and application server shut down
Field values do not change after parameterization and playback
Runtime errors causing scenario failure
Transactions failed
Unable to connect to remote servers
Analyzing log files
Analyzing Windows application log files
Analyzing Appeon Server log files
Analyzing active transaction log
Identifying Performance Bottlenecks of Web Server and Application Server
Identifying Performance Bottlenecks of DB Server
Deadlock analysis
Identifying Performance Bottlenecks of PB application
Analyzing performance bottlenecks of PB application
Tuning: DB Server
Tuning: Excessive Server Calls
Technique #1: partitioning transactions via stored procedures
Technique #2: partitioning non-visual logic via NVOs
Technique #3: eliminating recursive Embedded SQL
Technique #4: grouping multiple server calls with Appeon Labels
Tuning: Heavy Client
Technique #1: thin-out “heavy” Windows
Technique #2: thin-out “heavy” UI logic
Manipulating the UI in loops
Triggering events repeatedly
Performing single repetitive tasks
Initializing “heavy” tabs
Using ShareData or RowsCopy/RowsMove for data synchronization
Using computed fields
Using DataWindow expressions
Using complex filters
Using RowsFocusChanging/RowsFocusChanged events
Technique #3: offload “heavy” non-visual logic
Tuning: Large Data Transmissions
Technique #1: retrieving data incrementally
For Oracle database server
For all other database servers
Technique #2: minimizing excessive number of columns

Additional Functions

Appeon Performance Analyzer also provides the following additional functions:

Filter function

Appeon Performance Analyzer enables you to filter the functions or objects which you do not want to focus on temporarily. Here, in Appeon Performance Analyzer, to filter means to remove.

The filter function is only applicable to ActiveX calling analysis.

Click System | Filter menu item and the Filter Configuration dialog opens. Select Enable Filter.

Note: To enable the Filter function, you must make sure Enable Tracing is selected in System Configuration dialog.

If you want to analyze all the functions or objects in the application, make sure that Enable Filter is not selected.

Filter Configuration dialog

Filter function for ActiveX calls analysis

Go through the steps below to learn how to filter objects and functions for ActiveX calls analysis.

Step 1: Select View AX Calls under the View menu, all the ActiveX functions and objects called in the operation are listed.

View ActiveX calls

Step 2: Click menu System | Filter. In the Filter Configuration dialog, select Enable Filter.

Filter Configuration dialog

Step 3: In Filter, click the button. The Function Picker dialog opens.

Function Picker dialog

Step 4: Select the functions and/or objects in the Unselected list. Click the arrow button to move the selected items to the Selected list. Click OK to close the dialog.

The double-arrow buttons and are used to move all items from one list to the other.

Selected functions and objects

Now, the selected items are in the Filter area.

Note that they are in Group 1. You can have different groups for storing different selected items. The different groups can be all functions, all objects, or mixed with functions and objects.

Filter Configuration dialog

Step 5: In Option area, select Filter Unselected. This will display the selected items only, and hide the unselected items. If you select Filter Selected, it will hide the selected items, and display the unselected items.

Step 6: Click OK to close the dialog.

If Filter Unselected is selected, the analyzing panel is refreshed to show the selected items only (and hide the unselected items).

Result from Filter Unselected

If Filter Selected is selected, the analyzing panel is refreshed to show the unselected items only (and hind the selected items).

Result from Filter selected

Find function

You can find functions or objects by typing part of or complete name of the function or object.

If you click menu System | Find, a dialog box will pop up as below:

Find dialog

For example, type "applica" in the Find field, then click Find.

Find dialog

The Detail View window shows all the results related to "applica" in the Find in Tree tab.

Find results

Save As XML function

The Performance Analyzer allows you to save the analysis contents in the Analyzing panel as XML files.

If you click menu System | Save As XML, a dialog box will pop up as below:

Save As dialog

Input the file name and select the path, and then click the Save button to save the XML file.

New Root Item function

To obverse analysis data easily, you can click menu View | Clear All to clear the original analysis data, or create new root items.

If you click menu System | New Root Item, a dialog box will pop up as below:

New Root Item dialog

Input a root item name (eg. new) and click the OK button. A new root item named "new" is added in the Analysis panel.

New root item is added

After this, the root item "new" will be used to display the analysis data in a way similar to the default Root item.

Data in the new root item