SE30-Issue

[Former Member]

Hi all,

After applying patches to developement system transaction SE30 is not working properly. It shows database access timings in -ve. Also on initial screen Red light is shown for Reliability of time. If anybody had cone across such scenario please let me know the resolution for same. Any pointers to OSS note etc wiil be greatly appreciated.

Thanks,

Amol

[Former Member]

Hi Amol,

To troubleshoot performance, you need these tcode tools:-

ST04 – Database ß in here, check especially for Expensive SQLs (Detail Analysis à SQL Request)

ST02 – SAP buffers

ST06 – OS stats

ST05 – SQL trace

A few step which you can exercise to sort/identify performance issues.

• ST03, ST02, ST04 are the tcode for workload, tuning and DB Performance Monitoring codes.

• ST06 FOR Operation System Monitoring.

• SM51 OR SM50 is process overview which tells you the workprocess sequence. ( Ideally 10-15 process with OLTP and batch process scheduled at peak and off peak times respectively) say 8-17 hrs and 17-8 hrs for Batch Process)

Operation Mode can be configured in RZ04 tcode.

• Check for top CPU in ST06 tcode. CPU should not exceed more than 60% for long time for any process.

• Based of No. of instances ( Application Servers ) should have adequately sized.

• Most resources intensive process have to be scheduled in Batch Process ( in Background in Non Peak Hours )

• Look for unnecessary Jobs Active During Prime Time

• Look for Parameters Set To Your Business Process.

( RZ10, RZ11 ) Check Snote:0124361

• Refer Early Watch Alert Periodically for Overall System Performance.. ( Tcode SDCC )

Reward points for the same.

Regards,

Guru

[Former Member]

Hi,

You can refer the following oss notes, this might be helpful,

524298, 170470

Rgds,