SAP ECC 5.0 Performance Issue

[Former Member]

Hello All,

At our client location we are using SAP ECC 5.0 Server on Microsoft win 2003 with Ms-SQL 2000 Database

Since last week users are frequently facing performance issues system really behaves slow

Please help me in this regards,

System Information

OS: Win 2003 std X32 Bit

Ram : 4 GB

Daily user Logins: Approx 50

Profile Parameter Information:

Instance Profile:

abap/buffersize	450000
SAPSYSTEMNAME	PZP
INSTANCE_NAME	DVEBMGS00
SAPSYSTEM	00
rdisp/wp_no_dia	10
rdisp/wp_no_btc	6
rdisp/wp_no_vb	3
rdisp/wp_no_vb2	3
rdisp/wp_no_enq	2
rdisp/wp_no_spo	3
SAPGLOBALHOST	PRDSAP
PHYS_MEMSIZE	4000
DIR_TRANS	I:\usr\sap\trans
icm/server_port_0	PROT=HTTP,PORT=8000
DIR_CT_RUN	I:\usr\sap\PZP\SYS\exe\nuc\NtI386

Paging space : 20 GB

Please tell me do i need to set more profile parameter

Best regards,

Amol

[former_member182034]

hi amol,

For Parameters: Note 327494 - Configuration Parameters for SQL Server 2000

and

You need to monitor the

ST02 --> Red Swapping& Buffer anlysis

DB02 --> Check the missing Table indexes

ST04 --> Dialog Response time,Buffer Quality

SM50 --> check the execution time of Standard and Z reports  etc...

or check the guideline for Performance Issue.

PERFORMANCE MONITORING

Performance Notes

Regards,

[Former Member]

Hello Abdul,

As per yr suggestion  i have gone through DB02 but no missing indexes are there.

ST02- Roll area showing value 0 zero on disk

SM50- Execution time for z and standard report is about avg 40 Sec

Do i need to set any parameter related to memory?

Best Regards,

Amol

[former_member182034]

Dear,

If the status of transaction is looking Ok than you need to maintain the parameters as per SAP recommendation.

Regards,