cancel
Showing results for 
Search instead for 
Did you mean: 

Slow query performance

Former Member
0 Kudos

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

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Ravi,

Refer the threads in the following link -->

Hope it helps,

Sree

Answers (2)

Answers (2)

Former Member
0 Kudos

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
0 Kudos

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