Download QUERY User Guide - Winshuttle Software

Adaptive query throttling
To edit authorization objects
1. Click the Edit SAP Authorization Objects link.
2. In the Authorizations pane, locate the object you want, and then click Edit.
To delete an authorization object

In the Authorizations pane, locate the object you want, and then click Delete.
To add a new row for a new authorization object

Click Add a new row.
Adaptive query throttling
The administrator must give permission for this setting to be available to users. The user setting
appears in the Advanced Run Options pane.
Using a patent-pending algorithm, QUERY adaptively throttles the execution of the query on the
SAP server based on the current load on the SAP server. The available server resources are
calculated from the total number of open dialog processes. When over 50 percent of the dialog
processes on the SAP system are available, the query is executed at full speed, but when the
available server load starts falling below 50 percent, the execution of the query is dynamically
slowed.
Adaptive throttling addresses the performance concern around querying on a live transactional
system that query execution could take substantial computing resources that might compete
against regular SAP transactions, and adversely affect the performance of these transactions.
QUERY addresses this issue by allocating only available compute resources to execute queries in
the live SAP system.
The graph below shows the query performance time against the system load with and also without
the adaptive query throttling algorithm applied. When the throttling algorithm is applied, query
execution slows as the system load increases; however, without the algorithm, the query
executes in constant time and competes for resources with other transactions on the system.
107