Description

How to disable Query function module throttling

Applies to

Query 10.X

Cause
Query times out constantly.

Solution

If Query is timing out, try the following:

• Turn on data chunking ( in 10.X: Advanced Run Options > Data chunk value) or
• Turn off Adaptive Query Throttling.

Important: When you turn off Adaptive Query Throttling, you risk overtaxing the SAP system. Keep the data chunking feature turned on, and schedule the Query to run during off hours or, if you are using Query with Central, manage the query run in Central.

Here are the steps for turning off Adaptive Query Throttling:

1.Go to Tools > Options.
2.Select Admin Defaults.
3.Uncheck the Enable Adaptive Query Throttling box.

Because this very important feature prevents you from overtaxing server resources, we recommend that you turn Adaptive Query Throttling back on after your query runs.

Adaptive Query throttling is a very important feature, and it is enabled by default.  It is active only if you have the Winshuttle Function Module installed on your SAP system.

One major performance concern around giving users the ability to create queries against the live transactional system is that the Query execution could take substantial computing resources that might compete against regular SAP transactions. Winshuttle Query addresses this issue in a unique way by allocating only available computing resources to execute queries in the live SAP system. Using a patent-pending Adaptive Query Throttling™ technology, Query dynamically optimizes the execution of the queries based on the current load on the SAP server at any given time. 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. However, when the available server load starts falling below 50 percent, the execution of the Query is slowed down.

Additional information

Using Adaptive Query Throttling to address performance issues in Query

How to optimize process of downloading large amount of data without impacting system performance

For Central, go to Query preferences from the Central Administration Page