SAP Note 1139280 - BIA 7.00: Optimal settings for query performance

Component : TREX BI Accelerator - BW Accelerator

Solution : https://service.sap.com/sap/support/notes/1139280 (SAP Service marketplace login required)

Key words :
[global]use_old_trace_format = offstop_net_fail = 1[limits]max_pop_threads = <number, cpu cores>timeout_aggregate = 0threads_aggregate_calls = <number, cpu cores>max_comm_threads = <2 times <number, cpu resources solution ensure, [thread_limit]threads_aggregate = <number, cpu cores>trexexecutor, terms bi accelerator, adjust bia settings, cpu cores>>, bwa reason

Related Notes :

1363917BWA 7.00 & 7.20: Optimal settings for Intel Xeon 5570 CPUs
1358804BWA 7.00: Optimal settings for Revision 50 or later
1318214BWA 7.00: Suspicion of bad query performance