看懂ST03

TIMES	2007-1-25
Interval	06--07	08--09	09--10	10--11	11--12	12--13	13--14
Total Steps	1	1,179	5,831	5,313	4,346	491	3,723
Total Response Time	0	688	2,120	4,169	1,485	423	2,114
Average Response Time	0	583.5	363.6	784.8	341.6	860.8	567.9
Total CPU Time	0	62	205	202	183	17	117
Average CPU Time	0	52.9	35.2	37.9	42.1	34.2	31.5
Total DB Time	0	432	1,511	3,516	890	330	1,674
Average DB Time	0	366.4	259.1	661.7	204.8	671.4	449.6
Total DB Procedure Time	0	0	45.2	28.7	13.6	7.5	3.4
Average DB Procedure Time	0	0	7.8	5.4	3.1	15.2	0.9
Total WaitTime	0	0	1	1	1	0	1
Average WaitTime	0	0.3	0.1	0.2	0.2	0.3	0.3
Number of RoundTrips	0	610	1,966	1,518	1,545	184	1,149
Average Frontend network Time	0	808.3	247.2	187.9	184.8	3,475.60	151.3
Average GUI Time	0	172.7	61.7	78.9	91.8	134.8	86.1
数据库处理时间比例：明显比例太大。这个比例如果>>40%，那么明显是数据库性能问题。		0.6279349	0.7125963	0.84314475	0.5995316	0.7799721	0.7916887
响应时间组成	0	592.3	363.9	784.1	342	855.9	568.4
DB
Interval	06--07	08--09	09--10	10--11	11--12	12--13	13--14	14--15
Num of Sequential Reads	0	163,984	200,125	225,025	192,436	19,292	93,991	229,880
Total Seq. Read Time	0	398	1,281	3,116	797	283	1,480	1,882
Average Seq. Read Time	0	2.4	6.4	13.8	4.1	14.7	15.7	8.2
Num of Direct Reads	0	191,290	746,521	750,908	518,203	57,741	348,433	640,899
Total Time of Direct Reads	0	25	160	338	74	31	170	295
Average Time of Direct Reads	0	0.1	0.2	0.5	0.1	0.5	0.5	0.5
Num of LDB Changes	0	952	3,913	4,396	19,900	476	2,726	4,792
Total Time of LDB Changes	0	9	70	62	20	15	24	58
Average Time of LDB Changes	0	9	17.9	14	1	31.3	8.8	12.2
No of Log DB Calls	0	356,226	950,559	980,329	730,539	77,509	445,150	875,571
Average tome per Log DB call	0	1.2	1.6	3.6	1.2	4.3	3.8	2.6
No of physical db  read access	0	68,853	226,770	241,617	192,713	13,612	125,170	271,624
No of modified DB Recs	0	7	73	3	69	4	11	26
Records read from single record buffer	0	123,250	459,775	462,264	332,882	36,813	221,008	422,507
No of db procedure Calls	0	0	30	35	13	3	6	15
Total Time for DB procedure access	0	0	45.2	28.7	13.6	7.5	3.4	15.3
Average Time per db procedure access	0	0	1,506.90	819.6	1,046.90	2,484.00	563.7	1,018.90
连续读取时间(如果>>10ms表示数据库性能问题)		2.4	6.4	13.8	4.1	14.7	15.7	8.2
直接读取时间(如果>>2ms表示数据库性能问题)		0.1	0.2	0.5	0.1	0.5	0.5	0.5