Query Performance

[Former Member]

Hi all:

I have a doubt in query performance.Actually when i run a query from Purchasing multiprovider it takes 20 to 30 mins.

Problems:

1. I cant aggregate the infocube in a multiprovider.Because in Purchase order the report may create from brandwise.....

2.Compression is not possible in my scenarios.

Please suggest and give some inputs to me.

It would be great help.

Thanks in advance.

Rgds

MSK

[Former Member]

Hi Riccardo,

Do u have any docs or stpes for caching of data and any other docs for query performance..

Pls send to mail Id naga.jagadeesh@gmail.com

[Former Member]

Hi MSK,

to improve query performance you can:

1)use logical partition: create several identical cubes based on different years and use a MultiProvider to collect partitioned data.

2)create aggregates on the base of the query, use RSRTRACE to identify possible aggregates.

3)use precalculation and caching of data via Reporting Agent.

Ciao.

Riccardo.

[Former Member]

Hi Bhanu and Riccardo!!!

THanks for ur inputs.I will go for your steps and then update u the status.

Thanks.

I will assign points

Rgds

MSK

[Former Member]

Hi Riccardo,

Do u have any docs or stpes for caching of data and any other docs for query performance..

Pls send to mail Id suren.bw@gmail.com

Rgds

MSK

[Former Member]

Hi MSK,

if you need documentation on these points send me a mail to riccardoventu@virgilio.it, I will send you beck the related documents.

Ciao.

Riccardo.

[former_member188975]

Hi MSK,

You may find this useful (now or for later):

[original link is broken]

[former_member188975]

Hi MSK,

Run the query in RSRT with the multiprovider explain option checked on. It is possible that first the processor runs your query in parallel, but then terminates that and runs as sequential. This takes up time and performance.

http://help.sap.com/saphelp_nw04/helpdata/en/de/bcb73d73a5f972e10000000a114084/content.htm

Hope this helps...

[Former Member]

Hi Bhanu

Pls verify the steps doing now according to your guide...

1.RSRT

2.Run the query name in RSRT and parallely in Query analyzer.

From this two steps,it is help out for timimg sequnce.

Let me know.

Rgds

MSK

[Former Member]

Hi MSK;

Termination of parallel processing results in a loss of performance. If you want to improve the performance of a query for a MultiProvider, you can firstly check how the sub-queries are processed.

Execute the query via the query monitor (transaction RSRT) with the option Execute + Debug. Choose the MultiProvider Explain option. You can see messages in the upper part of the screen that displays the query result. Message DBMAN 146 shows you that parallel processing was terminated during query execution and the system restarted the process with sequential processing.

In such cases, we advise you to deactivate parallel processing for the MultiProvider. These functions can be found in the query monitor under query properties.

BK