August 5, 2009 at 1:17 am
Symptom
You want to configure optimal settings for Intel Xeon 5570 CPUs.
Other terms
BIA, BWA, Accelerator, speed, performance, X5570, indexing, filling, multi user, query, polestar, business objects explorer
Reason and Prerequisites
You are running SAP NetWeaver BW Accelerator on blade servers with Intel Xeon 5570 (codename Nehalem) multicore CPUs and you want to configure optimal settings.
Solution
To optimize the [...]
June 30, 2009 at 9:56 am
Symptom
You want to apply the optimal settings for SAP NetWeaver BW Accelerator Revision 50 or later.
Other terms
BIA, BWA, Accelerator, optimization, optimal parameters, explorer
Reason and Prerequisites
Prerequisite:
You have updated your BW Accelerator from Revision 49 or earlier to Revision 50 or later.
Reason:
As the update procedure does not change any existing parameter settings, there may be scope [...]
June 14, 2009 at 6:39 am
Symptom
Your cpu is not optimally used for queries
Other terms
BI Accelerator, optimization, Clovertown, Harpertown, Nehalem, performance, BWA, parallization, BWA
Reason and Prerequisites
You need to adjust BIA settings for optimal usage of cpu resources
Solution
Ensure that you have set the following paramters:
TREXIndexServer.ini:
[thread_limit]
threads_aggregate = <number of cpu cores>
timeout_aggregate = 0
threads_aggregate_calls = <number of cpu cores>
TREXExecutor.ini:
[global]
use_old_trace_format = off
stop_net_fail = 1
[limits]
max_pop_threads = [...]