Performance Tuning

[anvardheen_jabarullah]

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?

[Reagan]

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

RB

[bxiv]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[sujit_sharma]

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