on 08-28-2009 6:25 AM
HI,
We have ECC6.0 server(prdserver) Oracle 10g (Database) O/s windows 2003 Enterprise 32 bit RAM 12Gb.we are facing performence problem.how to improve performence. iam attaching existing parameters.please help me out.
-
abap/buffersize 2000000
SAPSYSTEM 00
login/system_client 090
INSTANCE_NAME DVEBMGS00
DIR_CT_RUN $(DIR_EXE_ROOT)\$(OS_UNICODE)\NTI386
DIR_EXECUTABLE $(DIR_INSTANCE)\exe
PHYS_MEMSIZE 512
rdisp/wp_no_dia 20
rdisp/wp_no_btc 4
icm/server_port_0 PROT=HTTP,PORT=80$$
ms/server_port_0 PROT=HTTP,PORT=81$$
rdisp/wp_no_enq 1
rdisp/wp_no_vb 3
rdisp/wp_no_vb2 3
rdisp/wp_no_spo 4
DIR_CLIENT_ORAHOME $(DIR_EXECUTABLE)
rdisp/max_wprun_time 60000
zcsa/system_language E
zcsa/installed_languages DE
rdisp/appc_ca_blk_no 100
rdisp/wp_ca_blk_no 600
login/create_sso2_ticket 2
login/accept_sso2_ticket 1
ms/server_port_0 PROT=HTTP,PORT=81$$
icm/server_port_0 PROT=HTTP,PORT=8000
icm/host_name_full prdserver.growel.com
DIR_ROLL ap/buffersizeD:\usr\sap\GPS\DVEBMGS0
DIR_PAGING D:\usr\sap\GPS\DVEBMGS00\data
DIR_DATA D:\usr\sap\GPS\DVEBMGS00\data
DIR_REORG D:\usr\sap\GPS\DVEBMGS00\data
DIR_TRANS
prdserver\sapmnt\trans
ztta/parameter_area 16000
icm/host_name_full prdserver.growel.com
DIR_ROLL ap/buffersizeD:\usr\sap\GPS\DVEBMGS00\data
DIR_PAGING D:\usr\sap\GPS\DVEBMGS00\data
DIR_DATA D:\usr\sap\GPS\DVEBMGS00\data
DIR_REORG D:\usr\sap\GPS\DVEBMGS00\data
DIR_TRANS
prdserver\sapmnt\trans
ztta/parameter_area 16000
DIR_TEMP .
DIR_SORTTMP D:\usr\sap\GPS\DVEBMGS00\data
install/codepage/appl_server 1100
abap/use_paging 0
ztta/roll_first 1024
ztta/roll_area 2550896
rdisp/ROLL_SHM 32768
rdisp/ROLL_MAXFS 32768
rdisp/PG_SHM 16384
rdisp/PG_MAXFS 32768
abap/heap_area_dia 4000000000
abap/heap_area_nondia 4000000000
abap/heap_area_total 4050733008
abap/heaplimit 60894464
abap/swap_reserve 20971520
ztta/roll_extension 2500733008
em/initial_size_MB 1068
em/blocksize_KB 1024
em/stat_log_size_MB 20
em/stat_log_timeout 6000
rdisp/wp_no_spo_Fro_max 3
em/address_space_MB 200
ztta/roll_first 1
em/max_size_MB 20000
rdisp/PG_MAXFS 32768
rdisp/ROLL_SHM 20000
Regards,
madhan
Edited by: Sakhalkar Swamy on Aug 28, 2009 7:25 AM
Edited by: Sakhalkar Swamy on Aug 28, 2009 7:26 AM
Edited by: Sakhalkar Swamy on Aug 28, 2009 7:27 AM
Hi ,
For performance of SAP system you need to consider many details before coming to conclusion.As you have sufficient RAM wiht you.I would like to suggest you to have a look into ST03n .Here you can check where exactly you are getting the issue.Either it is OS lvel or SAP level.
Please check in process if any CPU consuming process other SAP & your DB is running under this.if everything is fine in this regard you can check the load in SAP system if its too high then you may need to add application server for the same.Further you can have a look into SQL queries or particular Tcodes are taking too much resources.
Kindly have a lok in these points & let us know the details where exactly your bottleneck is ?
Thanks..
Mohit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mohit,
Thanks for your prompt reply.could u please assist me to how to do it.And iam sending some information from tcode sto3n.
and avery transaction getting slow.
Cumulated Users
58
Total Response Time (s)
79,685
Total CPU Time (s)
2,199
Total DB Time (s)
56,857
Regards,
Madhan
Edited by: Sakhalkar Swamy on Aug 28, 2009 8:06 AM
Hi,
for getting a clear picture it is very useful that you provide more informations from transaction ST03N. Therefore it would be a good idea to provide performance data.
Have a look at this link:
Link: [https://wiki.sdn.sap.com/wiki/display/MaxDB/WorkloadMonitor(ST03orST03N)]
Here you can find a table with performance data. It shows which process type needs how much response time. Could you be so kind to offer such table from your troubled system?
Kindly,
Andreas
Edited by: Andreas Tacke on Sep 4, 2009 10:57 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.