SAP NW ABAP performance advice required

[Former Member]

Hello experts,

I have just installed ECC6 with EHP6 on RHEL 6.3 with oracle 11.2.0.3.0 based on NW7.0 including EHP3 as a development environment.

SPs stack level 5

Kernel 720_Ext_UC_X86_64 patch level 401

RAM is 8 GB, and swap memory is 8 GB.

About 40 -50 concurrent users will use my dev system at the max.

Since my system is new, and no one is used it yet. Now I have few questions for optimal performance:

1. No of work processes come by its own when I installed system, i.e Dia 10, BTC 3, Enq 1, spo 1 upd 1 upd2 1. My question is as per above information, how many work process I can assign now to satisfy the needs, so that users will not experience any issue in coming days?

2. What memory related profile parameters I should keep/create in default and instance profile to make my system healthy? Please specify value as per above information mentioned.

3. What other relevant profile parameters, I should have and in which profile? My system is just new and I have not added any parameters other than what is given during installation by its own.

4. In ST02 I see, swaps are very high since I ran sgen, I am doubting when nobody is using the system the swaps are so high, and what will happen when users actually hit my system. Can anyone advice do I need to increase swap memory or do I neet increase or create certain parameter as in ST06 swap memory is just 4% free.

Tune summary
			Buffer					HitRatio %				Alloc. KB Freesp. KB				% Free Sp.				Dir. Size			FreeDirEnt				% Free Dir			Swaps			DB Accs
			Nametab (NTAB)																															0
			Table definition					94,89				6.735												20.000										1.103.102 1.651.531
			Field definition					94,89				31.562				3.935				13,12				20.000			10.385				51,93			583.321			594.045
			Short NTAB					99,91				3.625				2.810				93,67				5.000			4.386				87,72			0			614
			Initial records					80,65				6.625				3.649				60,82				5.000			1.929				38,58			175.071			178.142
																																		0
			program					78,48				400.000				226				0,06				100.000			85.654				85,65			351.591			1.098.033
			CUA					99,51				3.000				422				17,59				1.500			1.365				91,00			1.555			574
			Screen					99,72				4.297				3.653				89,25				2.000			1.920				96,00			140			1.165
			Calendar					100,00				488				26				5,44				200			24				12,00			0			176
			OTR									4.096				3.297				100,00				2.000			2.000				100,00			0
																																		0
			Tables																															0
			Generic Key					97,78				29.297				4.188				14,85				5.000			272				5,44			214			245.982
			Single record					88,12				10.000				1.752				17,75				500			449				89,80			78			246.300
																																		0
			Export/import					97,83				4.096				1.443				43,77				2.000			1.319				65,95			0
			Exp./ Imp. SHM									4.096				3.297				100,00				2.000			2.000				100,00			0
		SAP Memory				Curr.Use %			CurUse[KB]					MaxUse[KB]				In Mem[KB]				OnDisk[KB]				S			APCurCach			H	itRatio %
		Roll area				0,05			528					20.664				262.144				786.432				IDs						99,96
		Page area				0,04			368					32.512				262.144				786.432				Statement						99,00
		Extended memory				3,71			155.648					634.880				4.190.208				0										0,00
		Heap memory							0					204.460				0				0										0,00
		Call Stati			H		itRatio %			A	BAP/4 Req		A		BAP Fails		D		BTotCalls		A		vTime[ms]		D		BRowsAff.
		Select single			97,44					2.890.887			338.814				64.951				0				2.552.073
		Select			86,37					3.863.029			0				534.714				0				5.455.063
		Insert			0,00					24.669			9.212				24.778				0				17.826
		Update			0,00					71			1				125				0				70
		Delete			0,00					2.246			607				2.511				0				3.432
		Total			91,91					6.780.902			348.634				627.079				0				8.028.464

Thanks in advance.

[Former Member]

Hi Vicks,

A couple of pointers:

Increase your program buffer to 1GB

Double the size of the Table Definition buffer - you don't want SAP going to the DB to get schema information.

Double the size of the Initial Record buffer.

The rule of thumb for users is 6-8 per WP but as it's a DEV system, 1 developer debugging can tie up a wp.

Check the notes for Swap size on Unix as you may need to increase it.

What DB are you running and does it reside on the same server?  If so, the database buffer param's will likely need increasing from the delivered ones.

Hope this helps,

Graham

[Former Member]

Hello Friends,

Would you please reply of my above posts? Looking for some expert advice.

Thanks - vicks