Slow query performance

[Former Member]

Please i need help on the different ways to resolve slow query performance issues [on infocubes]. Any input will be highly appreciated.

Thanks

[Former Member · Accepted solution]

Hi Ravi,

Refer the threads in the following link -->

Hope it helps,

Sree

[Former Member]

Check your BW Statistics cube or the table RSDDSTAT and

check following parameter values:

Check queries with highest runtimes and check where most time has been consumed

OLAP init

DB

OLAP

Frontend

Check for ratio of selected to transferred

Depending on your situation you will be able to make use of Portal Cache, Pre-calculation, OLAP CACHE or Aggreagtes.

The SDN BW Performance Tuning Knowledge center provides lots of information this topic:

https://www.sdn.sap.com/sdn/developerareas/bi.sdn?page=bi_performance.htm

[Former Member]

Hi Ravi,

Query Performance is relevant to so many factors:

1.) Number of records in a CUBE

2.) CPU Speed

3.) Memory

4.) Current Server Load

5.) Design of your BW Info Providers

6.) Indexes

7.) Aggregates

Tweak any of these and you will feel a change in query performance. (<i>But the change could be either good or bad</i>) You can go on experiment which of these factors would benefit you...

Regards,

--Jkyle