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

Post Reply
Geeth
Posts: 79
Joined: Sun Mar 14, 2010 8:10 pm

high db time

Post by 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

Snowy
Posts: 28789
Joined: Mon Oct 21, 2002 2:33 pm
Location: 3.1415926535

Re: high db time

Post by 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

Post Reply