Skip to Content
0
Former Member
Oct 03, 2005 at 12:10 PM

SAP DB high utilization prob / bcoz of customized Z reports

21 Views

Dear All,

We are facing sap system slow problem.

our observation as below

AL08 - pick time no of user login 226

SM12 - shows EKKO , MARC , MBEW getting lock unlock.

al08 - shows customized zreports 16 to 17 running at a time. and bcoz of that high utlization on DB.

SM66 - shows 2/3 work processes running which is taking 500 to 800 seconds at a time.

DB utilization shows below sar report.

13:01:24 %usr %sys %wio %idle

13:02:24 57 12 31 0

13:03:24 58 9 33 0

13:04:24 57 10 32 1

13:05:24 59 13 27 1

13:06:24 61 10 28 1

13:07:24 58 10 30 2

13:08:24 62 10 25 2

DB utilization shows above idle % which is average withing 0,1,2

Plz help us in this regards or lets us know wayout

Most urgent.

Vijay Vadgaonkar

9371002546