how to tune BW 3.5 on MS SQL 2005?

[gautam_poddar2]

Hello,

I have installed BW 3.5 on MS SQL 2005 32 bit server but facing lot of performance issues. Server is going in hang stage as and when multiple reports are executed.

Pls suggest some parameters for enhancing the system performance.

SQL memory at database level is defined as 6 GB but in ST04 transaction its showing only 1.5:

Current Memory (MB) 1,563.1

SQL Memory Setting FIXED

Physical memeory is 16 GB---- where 8 GB is allocated for application and database is using 2 GB.

• RZ10 parameters are *******************

rdisp/plugin_auto_logout 3600

icm/keep_alive_timeout -1

rdisp/max_comm_entries 2000

gw/max_overflow_size 25000000

gw/max_conn 2000

gw/cpic_timeout 60

rsdb/esm/max_objects 10000

rsdb/esm/buffersize_kb 40000

rsdb/obj/buffersize 40000

ztta/roll_extension 2000683008

abap/swap_reserve 20971520

abap/heaplimit 40894464

abap/heap_area_total 2000683008

abap/heap_area_nondia 2000683008

abap/heap_area_dia 2000683008

rdisp/ROLL_MAXFS 32768

rdisp/ROLL_SHM 32768

ztta/roll_area 2000896

ztta/roll_first 1024

abap/use_paging 0

install/codepage/appl_server 1100

zcsa/installed_languages ED

zcsa/system_language E

rsdb/ntab/sntabsize 3000

rsdb/ntab/irbdsize 6000

rsdb/ntab/ftabsize 30000

rsdb/ntab/entrycount 30000

rdisp/wp_ca_blk_no 300

rdisp/appc_ca_blk_no 100

zcsa/presentation_buffer_area 20000768

rsdb/cua/buffersize 5000

rtbb/buffer_length 30000

zcsa/table_buffer_area 50000896

rdisp/keepalive 0

rdisp/max_wprun_time 7200

zcsa/db_max_buftab 10000

rtbb/max_tables 1000

abap/fieldexit yes

rec/client ALL

zcsa/calendar_area 1000000

zcsa/calendar_ids 400

abap/buffersize 500000

login/no_automatic_user_sapstar 0

SAPSYSTEMNAME BPW

login/system_client 410

INSTANCE_NAME DVEBMGS01

SAPSYSTEM 01

rdisp/wp_no_dia 11

rdisp/wp_no_btc 5

rdisp/wp_no_vb 3

rdisp/wp_no_vb2 2

rdisp/wp_no_enq 1

rdisp/wp_no_spo 3

SAPGLOBALHOST ndelntx48

PHYS_MEMSIZE 6000

DIR_TRANS D:\usr\sap\trans

icm/server_port_0 PROT=HTTP,PORT=8001

DIR_ROLL D:\usr\sap\BPW\DVEBMGS01\data

DIR_PAGING D:\usr\sap\BPW\DVEBMGS01\data

DIR_DATA D:\usr\sap\BPW\DVEBMGS01\data

DIR_REORG D:\usr\sap\BPW\DVEBMGS01\data

DIR_TEMP .

DIR_SORTTMP D:\usr\sap\BPW\DVEBMGS01\data

rdisp/PG_SHM 16384

rdisp/PG_MAXFS 32768

em/initial_size_MB 6000

em/blocksize_KB 1024

em/stat_log_size_MB 20

em/stat_log_timeout 0

em/address_space_MB 512

*********************

PLEASE ADVISE to improve performance.

Regards,

Ankita.

[Former Member]

Hi,

for parameters check Note 192658 - Setting parameters for BW systems

regards,

kaushal

[gautam_poddar2]

Hi Kaushal,

I have set all parameters acc to given note but after that also performance is not improved what else can i do??

Regards,

Ankita

[Former Member]

Hi,

you are using 32 bit OS .

activate /3GB in boot.ini

check Note 110172 - Windows: Transactions with large memory requirements

after activating this if you are still getting problem then create OSS message regarding performance issue.

regards,

kaushal

[antonio_voce]

Hi,

the topic is much complicated.

First you have to understand if there is software or hardware bottleneck.

To do this you have to analyze many issue :

For example ST02 for memory parameter configuration and buffer swaps.

Then trought ST06 you can analyze if there is CPU , memory or I/O bottleneck.

How many saps have your server ?

How many users ?

How many dialog steps ?

Then you can analyze onlyne situation, for example when there is lot of workload go in SM50 and see what happen ( WP occupied and so on )

ST03 for workload analisies