Question Re: Performance Tuning in Technology Q&A

Performance Tuning

anvardheen_jabarullah — Thu, 27 Jun 2013 08:52:37 GMT

Hi All,

We are having ECC Prod system in the Windows-oracle Environment. We often face performance issue also many time it is gone to hang state at that time couldn't able to connect.Actually This is new SAP System which gone for live recently.I would like to check whether its tuned fine or not? Let me know what are the parameters need to be tune normally after system is built?

Re: Performance Tuning

sujit_sharma — Thu, 27 Jun 2013 10:53:16 GMT

Hello Dheen,

You can tune your Windows server based on recommendation described in SAP Note: 88416 "Zero Administration Memory Management". Also keep an eye on "Oraarch" directory, it should have enough space always.

Regards,

SUJIT

Re: Performance Tuning

Former Member — Thu, 27 Jun 2013 10:54:09 GMT

Hi,

Firstly check ST02 and see how the buffers are set as you are likely to need to tune them. You also need to check the number of work processes and how busy they are - you may need to add more. how much RAM is allocated to SAP? How much to the DB? Who performed the production system sizing? It should have been the hardware supplier in partnership with your Basis team.

Which OS and DB are you running?

Hope this provides a few pointers.

Regards,

Graham

Re: Performance Tuning

Former Member — Thu, 27 Jun 2013 11:43:40 GMT

Open a task manager on the server and observe which processes are using cpu when the hangs occur.

This will tell you where to tune.

Cheers Michael

Re: Performance Tuning

bxiv — Thu, 27 Jun 2013 12:35:00 GMT

What does the EWA report show with the system you are having issues with?

Re: Performance Tuning

Former Member — Thu, 27 Jun 2013 12:48:36 GMT

hello,

Controlling Memory Management

abap/heaplimit: Work Process Restart

Memory Management Resources for One Work Process

ztta/roll_extension: Limit for Extended Memory

ztta/roll_extension_dia: EM Quota for Dialog Work Processes

ztta/roll_extension_nondia: EM Quota for Non-Dialog Work Processes

abap/heap_area_dia: Heap Memory Limit for Dialog Work Processes

abap/heap_area_nondia: Heap Memory Limit for Non-Dialog Work Processes

abap/heap_area_total: Total Quota for Heap Memory

ztta/roll_area: Roll Area

ztta/roll_first: Size of the Initial Allocation from the Roll Area

Memory Management Limitations

abap/heap_area_total: Heap Memory Limit

em/initial_size_MB: Extended Memory Pool Size

rdisp/ROLL_SHM: Roll Buffer Size

rdisp/ROLL_MAXFS: Maximum Roll File Size

rdisp/PG_SHM: Size of the Paging Buffer

rdisp/PG_MAXFS: Maximum Size of SAP Paging File

em/blocksize_KB: Segment Size for the Extended Memory

Memory Management Statistics

em/stat_log_size_MB: Statistics - User Context Size

em/stat_log_timeout: Statistics - User Context Size

Parameters for controlling the Release of SAP Memory for the Operating System

es/disclaim_threshold_MB

es/disclaim_coasting_time_alloc

es/disclaim_coasting_time_free

es/blockdisclaimsize_KB

es/freelist_compactor

WR,

PHB

Re: Performance Tuning

Former Member — Thu, 27 Jun 2013 12:52:09 GMT

Hello,

you need to check this parameter value,

#———-Parameters Changed ———–
rdisp/wp_no_dia = 10
rdisp/wp_no_btc = 3
rdisp/wp_no_enq = 1
rdisp/wp_no_vb = 3
rdisp/wp_no_vb2 = 3
rdisp/wp_no_spo = 1
login/system_client = 200 ***200 for standard system, 800 for IDES system
#———-Parameters Created———–
rdisp/keepalive_timeout = 600
rdisp/keepalive = 6H
ms/keepalive = 9999999
ms/conn_timeout = 100000
ms/http_timeout = 600
em/initial_size_MB = 1024
DIR_EPS_ROOT = \\<hos>\sapmnt\trans\EPS
DIR_TRANS = \\<host>1955\sapmnt\trans
login/create_sso2_ticket = 2
login/accept_sso2_ticket = 1
icm/host_name_full = <host>.acmeinc.net
login/no_automatic_user_sapstar = 0
sapgui/user_scripting_set_readonly = FALSE
sapgui/user_scripting_disable_recording = FALSE
sapgui/user_scripting = TRUE
zcsa/system_language = E
icm/keep_alive_timeout = 6000
icm/conn_timeout = 9999999
rdisp/max_wprun_time = 14400
rdisp/gui_auto_logout = 0
em/blocksize_KB = 4096
em/max_size_MB = 20000
em/address_space_MB = 512
rdisp/ROLL_MAXFS = 10000
rdisp/ROLL_SHM = 10000
rdisp/PG_MAXFS = 32768
rdisp/PG_SHM = 5000
rsdb/ntab/entrycount = 80000
rsdb/esm/max_objects = 10000
dbs/ora/array_buf_size = 1000000
rsdb/ntab/size = 60000
rsdb/ntab/irbdsize = 8000
sap/bufdir_entries = 10000
rsdb/obj/buffersize = 40000
rsdb/obj/max_objects = 20000
rdisp/max_arq = 2000
gw/max_conn = 2000
rdisp/tm_max_no = 2000
rdisp/max_comm_entries = 2000
gw/max_overflow_size = 25000000
enque/table_size = 10000
rsdb/ntab/ftabsize = 60000
abap/buffersize = 300000
abap/heap_area_dia = 2000000000
abap/heap_area_nondia = 2000000000
abap/heap_area_total = 2000000000
abap/heaplimit = 40894464
abap/swap_reserve = 20971520
vmcj/property/vmc.cachesiz = 50
vmcj/option/percentageCopyOnlySC = 20
vmcj/option/percentageSharedClasses = 10
zcsa/presentation_buffer_area = 4400128
zcsa/table_buffer_area = 30000128
ztta/roll_area = 2000000
ztta/roll_extension = 2000000000
ztta/roll_first = 1
vmcj/enable = on
vmcj/max_vm_heap_MB = 128
vmcj/option/gc/sharedWaterMark = 70
vmcj/option/ps = 1024M
vmcj/option/maxJavaHeap = 128M

Re: Performance Tuning

Reagan — Thu, 27 Jun 2013 18:35:43 GMT

Hello

First analyse Tx's ST02 and ST03N data.

Then shoot the sappfpar check against the instance profile to see the memory required.

Check the memory assigned to the database.

Now check the memory available on the machine.

Check the memory utilization at the OS level.

Also check the page file configuration

Make sure the system is set accroding the parameter recommendations for SAP on Windows

http://wiki.sdn.sap.com/wiki/display/Basis/Memory+parameters+for+SAP+on++64+bit+Windows

Good Luck