Performance issue

[Former Member]

Hi,

We are facing Performance issue with our Production servers.

How to do a comprehensive performance check (TCODEs, reports) to ensure system health??

regards,

Arul Sekar

[former_member204746 · Accepted solution]

Go for SAP course ADM315 Workload Analysis.

This is just too complicated to answer in a forum.

[Former Member]

Check SAP Earlywatch reports to find out some recommendations...

Additionally if u r running Oracle database u can use statspack or AWR reports to find out the performance bottlenecks.

Regards

Kausik

[Former Member]

Hi all,

Thanks for your reply.

with regards,

Arul Sekar

[fjhernanz]

Hi Arul,

Well, at least from a DB point of view and as a basis, I recommend to check at least the following items:

- Oracle parameters: All of them must be set accordingly with SAP note 830576 if you're on oracle 10 (You can use the script from note 1171650 to automatically check them)

- Ensure that statistics are current (note 838725)

- Install all the patches for your release (Note 1137346 for 10.2.0.4 and note 871096 for 10.2.0.2)

If all above is done, performance should be fine from DB point of view

Br,

Javier