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.
References:
https://help.sap.com/doc/saphelp_nw751abap/7.51.0/en-US/c7/b46000a76445f489e86f4c5814c7e8/frameset.h...
https://blogs.sap.com/2016/10/19/connectivity-news-abap-7.51/