Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
former_member4998
Active Contributor
4,454
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/

 
2 Comments
Labels in this area