SRM - Poor performance

[former_member233172]

We are working on SRM-Server 5.50 (SapNetweaver 2004s) on windows-SQL.

Users are complaining about horrible performance of the system.

As I am BC but don't know anything about SRM I can use some help.

In SM04 i see most of the users are using transactions BBPIV04 or BBPIV08 or BBPGLOBAL.

In column type I see Plug-in HTTP.

In ST06n I don't see any bottlenecks concerning CPU or Memory or Disk activity

In ST02 I see the ABAP Buffering is ok no swaps.

I think it is related to the integrated ITS that needs to be tuned but I can't find very helpful information.

Is there anybody that can point me to the right direction for further investigation or a specific guide how to tune SRM optimally?

Thx

[Former Member]

Hi,

1. Please make sure that your DB statistics are upto date

2. Please perform the steps explained in OSS Note 856803 - Improved performance in list displays

Hope this should solve your problem.

Regards

Kathirvel

[former_member233172]

Hi,

Thx for your input.

I think the note might be helpful...

Can you tell me how I can check if the DB statistics are up to date?

Thx.

[former_member183819]

Hi

check in tcode DB02 but take help from basis cosultant.

regards

Muthu

[former_member233172]

Hi

DB02 is ok...

No missing tables or indices.

and Autocreate statistics & autoupdate statistics is on

Thx.

I will check the note if helpfull I will let you know.

[former_member183819]

Hi

take help from Basis and look at the table spaces percentage.

regards

Muthu

[former_member233172]

Hi,

This is ok...it is SQL and the DB is in autoextend.

All datafiles have still 10% free so no real issues there.

Kr

Update : after performance analysis by SAP it turned out performance issues ware related due to poor development.

Edited by: Oxya Consulting on Aug 20, 2008 10:11 AM