This website is not affiliated with, sponsored by, or approved by SAP AG.

high db time

Basis (Basis Technology Modules: Basis Component/System Administration, GUIs)

Moderators: Snowy, thx4allthefish

high db time

Postby Geeth » Wed Nov 22, 2017 5:13 am

Hi Guru's

Some of my Z* program are very slow but CPU and RAM is good.Please see the workload over view
and suggest what could be the issue. The average DB time is also high.

Workload overview : Average time per step in ms

Code: Select all
Inter | Steps |T respT |0Time  |Process|AvgPrct|T CPU |CPU  | T DB tim |0DBTime|TTime| T roll | T waitT|0 wait T
-----------------------------------------------------------------------------------------------------------------
00--01   8,918   13,273   1,488.3   2,291   256.9   3,201   359.0   10,921   1,224.6   0.0   0.0   24   2.7
01--02   2,308   11,744   5,088.4   2,027   878.2   3,016   1,306.7   9,701   4,203.3   0.0   0.0   13   5.8
02--03   2,192   11,377   5,190.4   2,038   929.9   3,103   1,415.5   9,327   4,255.0   0.0   0.0   10   4.5
03--04   3,028   12,064   3,984.3   2,020   667.2   2,821   931.5   9,934   3,280.6   0.0   0.0   106   35.1
04--05   4,143   18,457   4,454.9   5,375   1,297.3   5,208   1,257.1   12,990   3,135.5   0.0   0.0   86   20.8
05--06   2,111   11,340   5,371.8   1,968   932.4   3,054   1,446.8   9,363   4,435.5   0.0   0.0   6   2.8
06--07   6,306   12,728   2,018.3   2,376   376.8   3,302   523.6   10,261   1,627.1   0.0   0.0   69   10.9
07--08   4,244   12,756   3,005.8   3,003   707.6   3,193   752.5   9,669   2,278.3   0.0   0.0   76   17.9
08--09   10,833   20,891   1,928.5   8,842   816.2   3,321   306.6   11,289   1,042.1   0.0   0.0   738   68.1
09--10   16,352   23,651   1,446.4   9,081   555.4   2,964   181.3   13,352   816.6   0.0   0.0   1,174   71.8
10--11   22,216   30,960   1,393.6   9,565   430.5   3,371   151.7   19,590   881.8   0.0   0.0   1,601   72.1
11--12   32,650   28,083   860.1   9,435   289.0   3,493   107.0   16,611   508.8   0.0   0.0   1,726   52.9
12--13   5,858   19,735   3,368.8   8,116   1,385.5   2,822   481.8   10,873   1,856.0   0.0   0.0   524   89.4
13--14   21,281   24,282   1,141.0   8,637   405.8   3,076   144.5   13,697   643.6   0.0   0.0   1,682   79.0
14--15   26,218   63,535   2,423.3   7,329   279.6   3,668   139.9   42,762   1,631.0   0.0   0.0   10,244   390.7
15--16   25,833   29,173   1,129.3   7,158   277.1   2,933   113.5   18,173   703.5   0.0   0.0   2,301   89.1
16--17   30,270   26,536   876.6   8,309   274.5   3,307   109.2   14,864   491.1   0.0   0.0   2,302   76.1
17--18   26,411   24,590   931.1   8,490   321.4   3,419   129.5   12,945   490.1   0.0   0.0   2,238   84.7

|\
\
Thanks
Geeth
Geeth
 
Posts: 79
Joined: Sun Mar 14, 2010 8:10 pm

Re: high db time

Postby Snowy » Wed Nov 22, 2017 2:02 pm

try to find which program is really slow. Once you find this, you transfer this to an ABAPPER and ask them to create more efficient coding.

thanks.
SapFans Moderator

Search: http://www.sapfans.com/forums/search.php
Notes: http://service.sap.com/notes
Help: http://help.sap.com
Rules: http://www.sapfans.com/forums/viewtopic.php?t=344127
Snowy
 
Posts: 28782
Joined: Mon Oct 21, 2002 2:33 pm
Location: 3.1415926535


Return to Basis

Who is online

Users browsing this forum: No registered users and 5 guests





This website is not affiliated with, sponsored by, or approved by SAP AG.