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

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: 71
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: 28768
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.