Skip to Content
Personal Insights
Author's profile photo Sreenivasulu Dasari

Enable HTTP/2 & Customize Number of parallel Sessions – Improve SAC Report performance

In this blog, I am going to share my experience – how we can improve SAC report performance by reducing long running queries time in BW.

Enable HTTP/2 & Customize Number of parallel Sessions: Its increase the number of parallel requests, backwards compatible protocol optimizes network and server resource usage to improve SAC report performance, when there are long running queries in BW.

Below are the steps to reduce the time for  long running queries (Database read time) in BW.

1. Activate  HTTP/2

HTTP/2 support can be activated or deactivated with parameter icm/HTTP/support_http2.  Activate HTTP/2 to set the below two parameter

icm/HTTP/support_http2 = TRUE (This will activate only HTTP/2) wdisp/support_http2_to_backend = TRUE (This will activate the HTTP/2 as a communication between back end system and front end system)

2. Customize Number of parallel sessions for BW data source   

Setup Number of parallel sessions for BW data source parameter value as a 9/12 (Value above 12 will be ignored) in SAC,but higher values for this setting will increase the load on BW server. You will need to make sure that BW server is configured to handle this load.

3. Increase icm/max_conn.

To make sure BW servers handle load increase icm/max_conn parameter value.
Set icm/max_conn to a higher value like 10000 (icm/max_conn = 10000). Please refer to SAP notes  2007212  and 737625 for more details.

Once we complete the above steps, around 30 to 40% SAC report performance gains by reducing long running queries time in BW.



Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Lijuan Guan
      Lijuan Guan

      Dear Dasari,

      thank you so much for the sharing, I have a question about the HTTP2 using:

      if it is a live connection from SAC to HANA DB, how to enable the http2 using?




      Author's profile photo Bala Narayan Ravanaiah
      Bala Narayan Ravanaiah

      Hi Victoria,

      As per the SAP note 2511489, The HTTP/2 Protocol is currently only supported for Live Data Connectivity between SAC and BW and SAP BPC using HTTPS.

      Best Regards,