Dashboard Query execution limitation

[Former Member]

Dear All,

When we  execute 7 to 8 dashboard at a time , ( each dashboard has average 8 queries ), then each dashboard take too much time.

Data fedretor admin tool, shows only three queries running at time while all other queries status  "waiting for execution".

some time queries run with system account user for long time continuously this also decrease dashboard performance

My BO system detail is given below

OS Windows 2008

RAM 64 GB

6 core IBM x3550

BO 4.0 SP6

please guide how we can increase dashboard performance and all queries run at a time with any delay.

Regards

Imran Khan

[sapanesh_agnihotri · Accepted solution]

Hi Imran,

1. Log into Central Management Console.

2. Navigate to Servers section and Select Manage -> New Server

3. Under Service Category (Web Intelligence Service) ->Select Service -> Web Intelligence Processing Service and create the server.

same way add or clone dashboard processing server as well.

Thanks,

Sapanesh

[Former Member · Accepted solution]

Hi,

I have add both servers . But result is same.

Data fedretor admin tool, shows only three queries running at time while all other queries status  "waiting for execution".

[arijit_das · Accepted solution]

Try changing the value of system parameter: MAX_CONCURRENT_MEMORY_CONSUMING_QUERIES

Pls refer to:

http://help.sap.com/businessobject/product_guides/boexir4/en/xi4_dfat_guide_en.pdf

Page 77

[Former Member · Accepted solution]

Please guide

this parameter ( MAX_CONCURRENT_MEMORY_CONSUMING_QUERIES)

we add  in data ferator service "AdaptiveProcessingServer" ...> properties..>Command Line Parameter ?

or some where else.

Regards

Imran Khan

[arijit_das · Accepted solution]

login to data federator admin tool

go to system parameters tab

change the value of the parameter

[Former Member · Accepted solution]

Thanks Arijit,

we have set this parameter

MAX_CONCURRENT_MEMORY_CONSUMING_QUERIES =10

Now 10 queries are running at time in data federator admin tool, But still its performance is not good.

Is there any parameter which increase performance ?

Regards

Khan

[arijit_das · Accepted solution]

For good performance, please make sure you have proper sizing of BOE installation. Pls check the sizing guide:https://scn.sap.com/docs/DOC-33126

Also, it is very important to follow the dashboards best practices:http://wiki.scn.sap.com/wiki/display/BOBJ/Dashboards+%28Xcelsius%29+General+Best+Practices

[Former Member · Accepted solution]

Thanks Again,

The main issue resolved. Now looking performance in depth

Best Regards

khan

[Former Member]

Hi Imran,

Increase number Dashboard Processing servers to improve performance.

Regards,

Ambreen.

[Former Member]

Hi Ambreen ,

I am confuse .

Increase number Dashboard Processing servers or  web intelligence processing service

OR Both

[arijit_das]

how many webi processing servers do you have ?

[Former Member]

I have one "SAPBOP.WebIntelligenceProcessingServer" and one "SAPBOP.WebApplicationContainerServer"

servers

[arijit_das]

can you check by creating a few clones of WebIntelligenceProcessingServer ? it can help in parallel execution of queries.

[Former Member]

Can u please guide me how many  web processing server we clone.

currently web processing server containing 6 services

information engin service

SSO service

trace log service

web intelligence common service

web intelligence core service

web intelligence processing service

[arijit_das]

There is a sizing guide available in sap site. I do not have the link with me right now. You can search for the same.