Improves the performance of activating DSO data

Some system performance bottlenecks may occur during DSO data activation. The following are some practical tips for improving the activation speed:

1. Clear unnecessary system processes in the background

Tcode: rsbtcdel2, sm65 =

2. update statistics

Updating statistics mainly updates the statistics of database tables,

Why is this statistics updated?

Because the database query engine performs query execution plans based on statistics, this is a high-waterlevel database problem. What is high water level?

For example, if a table stores 1 piece of data, but the value of statistics is 100, the query execution plan generated by the table actually stores pieces of data is the same, so the time used for data query is the same, updating statistics allows the query engine to effectively analyze physical storage and generate effective execution plans.

3. Do not select activate to generate sid When DSO does not do data mart

The background program rsbatch_execute_process is used to generate Sid when activating DSO. In many cases, it is slow at this stage.

Why activate DSO to generate Sid?

It is mainly used for data mart data extraction reports. Sid is used together with primary data and business data = to accelerate the report data extraction time. This is mainly a performance issue.

Why not need DSO to generate Sid?

The data storage layer is used to store data. Therefore, no Sid is required. Generating a Sid will increase server resource consumption,

4. Cluster again

Generally, data is not sharded during data loading. You can communicate with basis to split data into clusters in different business scenarios.

What is a cluster used? Simply put, it is easier to classify things in different places so as to find things?

5. DSO settings

Tcode rsodso_settings

Notes: https://websmp130.sap-ag.de/sap (bd16aczjptawmq =)/BC/bsp/SPNs/sapnotes/index2.htm? Numm = 1118205

6. bw settings

This is mainly because basis enables the maximum number of server resources to be used when activating DSO through a series of parameter configurations ,,,

Notes: https://websmp230.sap-ag.de/sap (bd16aczjptawmq =)/BC/bsp/SPNs/sapnotes/index2.htm? Numm = 0000192658 & nlang = 1