Hallo,
Ich brauche dringend Hilfe wir haben ständig Probleme bei der Performance mit der Maxdb
Ich verstehe nicht wie ich die MaxDB dazu kriege dass diese schneller wird.
kann sich das wer anschauen von Euch Profis und mal sagen was pauschal schon mal dieses "isolated index " beheben kann.
SQL commands executed: 54332, avg. 32.57 per second
* W3 4 isolated index range accesses, selectivity 0.02%: 8954 rows read, 2 rows qualified
* W3 ROW6: collision rate 105577.76%, 220064180 collisions, no waits, 208438 accesses on region 179
* W3 ROW3: collision rate 70710.84%, 148416403 collisions, no waits, 209892 accesses on region 176
* W3 FBM: collision rate 103958.46%, 302297694 collisions, no waits, 290787 accesses on region 183
* W1 CONVT0: collision rate 92.62%, 263684 collisions, no waits, 284700 accesses on region 2075
* W1 runtime of last savepoint: 373 seconds
* I Garbage collector tasks activated 1451 times, currently active: 0
* I server tasks activity. Dispatches: 3068189, physical reads: 11790, physical writes: 49
* I backup activity: number of pages read 772008, written 772008
* W1 User task 194 blocked in state 'JobWait BckRec' since 11761s, application pid 28482
* I CPU utilization: instance ST1: 49.46% (usr: 46.11%, sys: 3.35%), host: 459.76% (usr: 47.49%, sys: 14.67%, wio: 397.6%, idle: 313.77%)
* I Number of pages marked for reclustering: 25, clustered read operations: 11, clustered pages read: 25
===== #29 at 2013-11-08 00:40:36
* I SQL commands executed: 19318, avg. 21.32 per second
* W3 5 isolated index range accesses, selectivity 0.04%: 8956 rows read, 4 rows qualified
* W3 FBM: collision rate 1941.14%, 9078654 collisions, no waits, 467696 accesses on region 183
* I 17 of 258 read ahead requests could not be fulfilled, configured number of parallel requests (MaxDataAreaReadAheadRequests): 12
* I Garbage collector tasks activated 5170 times, currently active: 0
* I server tasks activity. Dispatches: 752491, physical reads: 13194, physical writes: 46
* I backup activity: number of pages read 1380576, written 1380568
* W1 User task 194 blocked in state 'JobWait BckRec' since 12670s, application pid 28482
* I CPU utilization: instance ST1: 74.15% (usr: 69.64%, sys: 4.51%), host: 205.28% (usr: 69.97%, sys: 12.43%, wio: 122.88%, idle: 591.64%)
* I Number of pages marked for reclustering: 20, clustered read operations: 7, clustered pages read: 20
===== #30 at 2013-11-08 00:55:40
* W3 3 isolated index range accesses, selectivity 0.02%: 8954 rows read, 2 rows qualified
* I Garbage collector tasks activated 2200 times, currently active: 0
* I server tasks activity. Dispatches: 600867, physical reads: 10633, physical writes: 25
* I backup activity: number of pages read 1384120, written 1384120
* W1 User task 194 blocked in state 'JobWait BckRec' since 13573s, application pid 28482
* I CPU utilization: instance ST1: 71.32% (usr: 66.67%, sys: 4.65%), host: 180.84% (usr: 68.44%, sys: 13.29%, wio: 99.11%, idle: 619.71%)
===== #31 at 2013-11-08 01:10:52
* I SQL commands executed: 229438, avg. 249.46 per second
* W1 Catalog cache hitrate (SQL Pages) 26.43%, 835857 of 1136212 accesses failed
* I Garbage collector tasks activated 4780 times, currently active: 0
* I server tasks activity. Dispatches: 1515872, physical reads: 3404, physical writes: 46
* I backup activity: number of pages read 1201720, written 1201720
* W1 User task 194 blocked in state 'JobWait BckRec' since 14493s, application pid 28482
* I CPU utilization: instance ST1: 70% (usr: 63.7%, sys: 6.3%), host: 354.57% (usr: 67.61%, sys: 21.09%, wio: 265.87%, idle: 412.72%)
===== #32 at 2013-11-08 01:26:05
* I SQL commands executed: 46972, avg. 51.74 per second
* W3 3 isolated index range accesses, selectivity 0.02%: 8954 rows read, 2 rows qualified
* W1 FBM: collision rate 310.11%, 1631905 collisions, no waits, 526232 accesses on region 183
* I Garbage collector tasks activated 18840 times, currently active: 0
* I server tasks activity. Dispatches: 731605, physical reads: 7344, physical writes: 22
* I backup activity: number of pages read 1877144, written 1877152
* W1 User task 194 blocked in state 'JobWait BckRec' since 15402s, application pid 28482
* W2 User task 102 processing same command since 1829s, 2 dispatches, application pid 26920
* I CPU utilization: instance ST1: 76.57% (usr: 71.18%, sys: 5.39%), host: 214.85% (usr: 72.5%, sys: 14.74%, wio: 127.61%, idle: 585.92%)
===== #33 at 2013-11-08 01:41:11
* I SQL commands executed: 39206, avg. 43.39 per second
* I Garbage collector tasks activated 15260 times, currently active: 0
* I server tasks activity. Dispatches: 906948, physical reads: 21573, physical writes: 44
* I backup activity: number of pages read 2290160, written 2290152
* W1 User task 194 blocked in state 'JobWait BckRec' since 16307s, application pid 28482
* I CPU utilization: instance ST1: 84.75% (usr: 77.79%, sys: 6.96%), host: 185.41% (usr: 80.88%, sys: 18.23%, wio: 86.3%, idle: 621.33%)
===== #34 at 2013-11-08 01:56:20
* I SQL commands executed: 93067, avg. 102.68 per second
* W3 3 isolated index range accesses, selectivity 0.02%: 8954 rows read, 2 rows qualified
* I Garbage collector tasks activated 36150 times, currently active: 0
* I server tasks activity. Dispatches: 811597, physical reads: 9038, physical writes: 25
* I backup activity: number of pages read 2081176, written 2081176
* W1 User task 194 blocked in state 'JobWait BckRec' since 17214s, application pid 28482
* I CPU utilization: instance ST1: 81.37% (usr: 75.74%, sys: 5.62%), host: 194.82% (usr: 78.94%, sys: 15.66%, wio: 100.22%, idle: 612.24%)
===== #35 at 2013-11-08 02:11:23
* I SQL commands executed: 145496, avg. 161.37 per second
* I Garbage collector tasks activated 27150 times, currently active: 0
* I server tasks activity. Dispatches: 772617, physical reads: 2619, physical writes: 49
* I backup activity: number of pages read 1986608, written 1986608
* W1 User task 194 blocked in state 'JobWait BckRec' since 18116s, application pid 28482
* I CPU utilization: instance ST1: 86.92% (usr: 81.04%, sys: 5.88%), host: 225.5% (usr: 83.59%, sys: 17.18%, wio: 124.72%, idle: 574.61%)
===== #36 at 2013-11-08 02:26:25
* I SQL commands executed: 24953, avg. 27.7 per second
* W3 3 isolated index range accesses, selectivity 0.02%: 8954 rows read, 2 rows qualified
* W1 FBM: collision rate 68.63%, 391016 collisions, no waits, 569713 accesses on region 183
* I Garbage collector tasks activated 9560 times, currently active: 0
* I server tasks activity. Dispatches: 537262, physical reads: 12624, physical writes: 19
* I backup activity: number of pages read 1057147, written 1057480
* W1 User task 194 blocked in state 'JobWait BckRec' since 19019s, application pid 28482
* W2 User task 134 processing same command since 2712s, 2 dispatches, application pid 26928
* I CPU utilization: instance ST1: 71.43% (usr: 67.44%, sys: 3.99%), host: 196.68% (usr: 69.66%, sys: 11.18%, wio: 115.84%, idle: 605.32%)
===== #37 at 2013-11-08 02:41:33
* I SQL commands executed: 73991, avg. 81.65 per second
* W3 3 isolated index range accesses, selectivity 0.02%: 8954 rows read, 2 rows qualified
* W3 FBM: collision rate 2296.92%, 13735908 collisions, no waits, 598015 accesses on region 183
* I Garbage collector tasks activated 20764 times, currently active: 0
* I server tasks activity. Dispatches: 549212, physical reads: 6837, physical writes: 43
* I backup activity: number of pages read 1061635, written 1061680
* W1 User task 194 blocked in state 'JobWait BckRec' since 19926s, application pid 28482
* I CPU utilization: instance ST1: 68.47% (usr: 64.28%, sys: 4.19%), host: 199.78% (usr: 65.38%, sys: 11.69%, wio: 122.71%, idle: 601.98%)
===== #38 at 2013-11-08 02:56:35
* I SQL commands executed: 62100, avg. 68.84 per second
* I Garbage collector tasks activated 23255 times, currently active: 0
* I server tasks activity. Dispatches: 391827, physical reads: 8685, physical writes: 25
* I backup activity: number of pages read 656711, written 656360
* W1 User task 194 blocked in state 'JobWait BckRec' since 20829s, application pid 28482
* I CPU utilization: instance ST1: 53.49% (usr: 48.73%, sys: 4.76%), host: 301.22% (usr: 51.72%, sys: 14.06%, wio: 235.44%, idle: 496.79%)
===== #39 at 2013-11-08 03:11:42
* I SQL commands executed: 91282, avg. 100.82 per second
* I Garbage collector tasks activated 16364 times, currently active: 0
* I server tasks activity. Dispatches: 447644, physical reads: 5923, physical writes: 50
* I backup activity: number of pages read 782179, written 782152
* W1 User task 194 blocked in state 'JobWait BckRec' since 21736s, application pid 28482
* I CPU utilization: instance ST1: 63.8% (usr: 59.49%, sys: 4.3%), host: 294.59% (usr: 62.14%, sys: 13.13%, wio: 219.32%, idle: 497.79%)
* I Number of pages marked for reclustering: 10, clustered read operations: 6, clustered pages read: 10
===== #40 at 2013-11-08 03:26:48
* I SQL commands executed: 116212, avg. 127.78 per second
* W3 3 isolated index range accesses, selectivity 0.02%: 8954 rows read, 2 rows qualified
* I Garbage collector tasks activated 41380 times, currently active: 0
* I server tasks activity. Dispatches: 34456, physical reads: 423, physical writes: 21
* I backup activity: number of pages read 65921, written 66312
* I CPU utilization: instance ST1: 11.1% (usr: 10%, sys: 1.1%), host: 84.18% (usr: 9.67%, sys: 2.97%, wio: 71.54%, idle: 708.24%)
===== #41 at 2013-11-08 03:41:54
* I SQL commands executed: 103530, avg. 114.22 per second
* W3 3 isolated index range accesses, selectivity 0.02%: 8954 rows read, 2 rows qualified
* I Garbage collector tasks activated 38020 times, currently active: 0
* I server tasks activity. Dispatches: 13373, physical reads: 11334, physical writes: 45
* I CPU utilization: instance ST1: 6.17% (usr: 5.51%, sys: 0.66%), host: 50.61% (usr: 4.08%, sys: 1.43%, wio: 45.09%, idle: 744.98%)
===== #42 at 2013-11-08 03:57:02
* I SQL commands executed: 66044, avg. 72.72 per second
* I Garbage collector tasks activated 23860 times, currently active: 0
* I server tasks activity. Dispatches: 20260, physical reads: 15799, physical writes: 24
* I CPU utilization: instance ST1: 14.3% (usr: 12.98%, sys: 1.32%), host: 71.95% (usr: 10.56%, sys: 2.2%, wio: 59.19%, idle: 719.47%)
===== #43 at 2013-11-08 04:12:13
* I SQL commands executed: 347015, avg. 379.32 per second
* W3 4 isolated index range accesses, selectivity 0.02%: 8954 rows read, 2 rows qualified
* W1 Lock list escalations: 1
* W1 3 log queue overflows for log queue 1
* W2 max Log queue filling: 100.00 %
* I Garbage collector tasks activated 38560 times, currently active: 0
* I server tasks activity. Dispatches: 21340, physical reads: 19184, physical writes: 53
* I CPU utilization: instance ST1: 19.23% (usr: 17.27%, sys: 1.97%), host: 89.18% (usr: 18.03%, sys: 3.72%, wio: 67.43%, idle: 705.79%)
===== #44 at 2013-11-08 04:27:28
* I SQL commands executed: 208705, avg. 230.17 per second
* W3 3 isolated index range accesses, selectivity 0.02%: 8954 rows read, 2 rows qualified
* I Garbage collector tasks activated 71230 times, currently active: 0
* I server tasks activity. Dispatches: 15465, physical reads: 11807, physical writes: 23
* I CPU utilization: instance ST1: 8.93% (usr: 7.83%, sys: 1.1%), host: 53.14% (usr: 6.62%, sys: 2.65%, wio: 43.88%, idle: 742.34%)
===== #45 at 2013-11-08 04:42:33
* I SQL commands executed: 187917, avg. 207.48 per second
* W3 3 isolated index range accesses, selectivity 0.02%: 8954 rows read, 2 rows qualified
* I Garbage collector tasks activated 69510 times, currently active: 0
* I server tasks activity. Dispatches: 17023, physical reads: 13306, physical writes: 44
* I CPU utilization: instance ST1: 9.71% (usr: 8.61%, sys: 1.1%), host: 41.28% (usr: 5.85%, sys: 1.88%, wio: 33.55%, idle: 753.09%)
===== #46 at 2013-11-08 04:57:39
* I SQL commands executed: 197171, avg. 216.98 per second
* W2 5905 table scans, selectivity 1.51%: 425068 rows read, 6429 rows qualified
* I Garbage collector tasks activated 64720 times, currently active: 0
* I server tasks activity. Dispatches: 41517, physical reads: 38192, physical writes: 21
* I CPU utilization: instance ST1: 12.54% (usr: 11.66%, sys: 0.88%), host: 41.91% (usr: 12.54%, sys: 2.09%, wio: 27.28%, idle: 757.54%)
===== #47 at 2013-11-08 05:12:49
* I SQL commands executed: 147956, avg. 163.02 per second
* W3 4 isolated index range accesses, selectivity 0.02%: 8954 rows read, 2 rows qualified
* I Garbage collector tasks activated 10500 times, currently active: 0
* I server tasks activity. Dispatches: 28964, physical reads: 28319, physical writes: 56
* I CPU utilization: instance ST1: 15.2% (usr: 13.88%, sys: 1.32%), host: 49.67% (usr: 12.67%, sys: 2.53%, wio: 34.47%, idle: 744.93%)
* I Number of pages marked for reclustering: 5, clustered read operations: 5, clustered pages read: 5
===== #48 at 2013-11-08 05:27:56
* I SQL commands executed: 21510, avg. 23.6 per second
* W3 3 isolated index range accesses, selectivity 0.02%: 8954 rows read, 2 rows qualified
* I Garbage collector tasks activated 9740 times, currently active: 0
* I server tasks activity. Dispatches: 34006, physical reads: 33322, physical writes: 23
* I CPU utilization: instance ST1: 6.13% (usr: 5.25%, sys: 0.88%), host: 25.49% (usr: 3.72%, sys: 1.64%, wio: 20.13%, idle: 771.99%)
===== #49 at 2013-11-08 05:43:11
* I SQL commands executed: 54403, avg. 60.18 per second
* W3 3 isolated index range accesses, selectivity 0.02%: 8954 rows read, 2 rows qualified
* I Garbage collector tasks activated 22030 times, currently active: 0
* I server tasks activity. Dispatches: 56834, physical reads: 55316, physical writes: 44
* I CPU utilization: instance ST1: 7.85% (usr: 6.63%, sys: 1.22%), host: 23.31% (usr: 5.19%, sys: 2.1%, wio: 16.02%, idle: 774.7%)
===== #50 at 2013-11-08 05:58:16
* I SQL commands executed: 167686, avg. 185.56 per second
* W1 Catalog cache hitrate (SQL Pages) 31.70%, 736876 of 1078860 accesses failed
* I Garbage collector tasks activated 23202 times, currently active: 0
* I server tasks activity. Dispatches: 36314, physical reads: 34826, physical writes: 22
* I CPU utilization: instance ST1: 12.83% (usr: 11.5%, sys: 1.33%), host: 34.73% (usr: 12.28%, sys: 2.43%, wio: 20.02%, idle: 763.27%)
===== #51 at 2013-11-08 06:13:18
* I SQL commands executed: 204440, avg. 223.01 per second
* I Garbage collector tasks activated 39190 times, currently active: 0
* I server tasks activity. Dispatches: 51931, physical reads: 49498, physical writes: 50
* I CPU utilization: instance ST1: 19.63% (usr: 17.88%, sys: 1.74%), host: 49.29% (usr: 18.87%, sys: 3.82%, wio: 26.61%, idle: 748.09%)
===== #52 at 2013-11-08 06:28:36
* I SQL commands executed: 65341, avg. 71.4 per second
* W3 3 isolated index range accesses, selectivity 0.02%: 8954 rows read, 2 rows qualified
* I Garbage collector tasks activated 25550 times, currently active: 0
* I server tasks activity. Dispatches: 38808, physical reads: 37484, physical writes: 23
* I CPU utilization: instance ST1: 7.1% (usr: 6.11%, sys: 0.98%), host: 25.98% (usr: 5.57%, sys: 1.97%, wio: 18.45%, idle: 773.25%)
===== #53 at 2013-11-08 06:43:52
* I SQL commands executed: 251971, avg. 275.75 per second
* W3 3 isolated index range accesses, selectivity 0.02%: 8954 rows read, 2 rows qualified
* I Garbage collector tasks activated 97450 times, currently active: 0
* I server tasks activity. Dispatches: 41987, physical reads: 36900, physical writes: 47
* I CPU utilization: instance ST1: 10.61% (usr: 9.19%, sys: 1.42%), host: 30.09% (usr: 8.42%, sys: 2.41%, wio: 19.26%, idle: 771.44%)
===== #54 at 2013-11-08 06:59:06
* I SQL commands executed: 420732, avg. 460.89 per second
* I Garbage collector tasks activated 132920 times, currently active: 0
* I server tasks activity. Dispatches: 50802, physical reads: 42880, physical writes: 22
* I CPU utilization: instance ST1: 22.45% (usr: 20.59%, sys: 1.86%), host: 50.05% (usr: 20.81%, sys: 3.61%, wio: 25.63%, idle: 751.7%)
===== #55 at 2013-11-08 07:14:18
* I SQL commands executed: 331255, avg. 364.09 per second
* W3 3 isolated index range accesses, selectivity 0.02%: 8954 rows read, 2 rows qualified
* I Garbage collector tasks activated 139570 times, currently active: 0
* I server tasks activity. Dispatches: 33399, physical reads: 25943, physical writes: 49
* I CPU utilization: instance ST1: 14.29% (usr: 12.31%, sys: 1.98%), host: 49.67% (usr: 10%, sys: 3.41%, wio: 36.26%, idle: 747.69%)
===== #56 at 2013-11-08 07:29:29
* I SQL commands executed: 189834, avg. 207.99 per second
* W3 3 isolated index range accesses, selectivity 0.02%: 8954 rows read, 2 rows qualified
* I Garbage collector tasks activated 77940 times, currently active: 0
* I server tasks activity. Dispatches: 45350, physical reads: 41076, physical writes: 23
* I CPU utilization: instance ST1: 11.83% (usr: 10.19%, sys: 1.64%), host: 25.19% (usr: 8.11%, sys: 2.63%, wio: 14.46%, idle: 772.4%)
===== #57 at 2013-11-08 07:44:41
* I SQL commands executed: 126223, avg. 137.87 per second
* W3 3 isolated index range accesses, selectivity 0.02%: 8954 rows read, 2 rows qualified
* I Garbage collector tasks activated 53370 times, currently active: 0
* I server tasks activity. Dispatches: 36899, physical reads: 33877, physical writes: 43
* I CPU utilization: instance ST1: 10.15% (usr: 8.73%, sys: 1.42%), host: 18.23% (usr: 6.11%, sys: 2.18%, wio: 9.93%, idle: 777.73%)
===== #58 at 2013-11-08 07:59:58
* I SQL commands executed: 287133, avg. 310.82 per second
* I Garbage collector tasks activated 96640 times, currently active: 0
* I server tasks activity. Dispatches: 38031, physical reads: 32986, physical writes: 22
* I CPU utilization: instance ST1: 18.72% (usr: 16.88%, sys: 1.84%), host: 39.29% (usr: 15.58%, sys: 3.57%, wio: 20.13%, idle: 756.93%)
===== #59 at 2013-11-08 08:15:21
* I SQL commands executed: 114549, avg. 125.81 per second
* W2 Selects and fetches selectivity 1.57%: 12670 selects and fetches, 1625649 rows read, 25555 rows qualified
* W1 102 isolated index range accesses, selectivity 4.15%: 9340 rows read, 388 rows qualified
* I Garbage collector tasks activated 39940 times, currently active: 0
* I server tasks activity. Dispatches: 35118, physical reads: 32611, physical writes: 50
* I CPU utilization: instance ST1: 10.87% (usr: 9.22%, sys: 1.65%), host: 40.18% (usr: 6.04%, sys: 2.74%, wio: 31.39%, idle: 751.37%)
* I Number of pages marked for reclustering: 279, clustered read operations: 59, clustered pages read: 279
===== #60 at 2013-11-08 08:30:33
* I SQL commands executed: 62690, avg. 69.49 per second
* W1 Data cache hitrate (SQL Pages) 98.95%, 55630 of 5301699 accesses failed
* W2 Selects and fetches selectivity 2.46%: 11167 selects and fetches, 2434721 rows read, 59858 rows qualified
* W2 81 isolated index range accesses, selectivity 2.23%: 9156 rows read, 204 rows qualified
* I 228 of 3112 read ahead requests could not be fulfilled, configured number of parallel requests (MaxDataAreaReadAheadRequests): 12
* I Garbage collector tasks activated 23550 times, currently active: 0
* I server tasks activity. Dispatches: 87435, physical reads: 33726, physical writes: 39
* W1 Number of tables where update statistics is required: 1
* I CPU utilization: instance ST1: 6.2% (usr: 4.87%, sys: 1.33%), host: 15.17% (usr: 5.65%, sys: 2.44%, wio: 7.09%, idle: 783.5%)
* I Number of pages marked for reclustering: 1174, clustered read operations: 281, clustered pages read: 1174
===== #61 at 2013-11-08 08:45:35
* W3 3 isolated index range accesses, selectivity 0.02%: 8954 rows read, 2 rows qualified
* I Garbage collector tasks activated 1780 times, currently active: 0
* I CPU utilization: instance ST1: 0.67% (usr: 0.55%, sys: 0.11%), host: 3.66% (usr: 1.88%, sys: 0.67%, wio: 1.11%, idle: 795.79%)
===== #62 at 2013-11-08 09:00:37
* I SQL commands executed: 51549, avg. 57.16 per second
* I Garbage collector tasks activated 1750 times, currently active: 0
* I CPU utilization: instance ST1: 9.41% (usr: 9.19%, sys: 0.22%), host: 15.61% (usr: 10.85%, sys: 1.33%, wio: 3.43%, idle: 783.5%)
===== #63 at 2013-11-08 09:15:41
* I SQL commands executed: 190318, avg. 208.07 per second
* W3 3 isolated index range accesses, selectivity 0.02%: 8954 rows read, 2 rows qualified
* W1 Lock list escalations: 1
* W2 LOGQUE7: collision rate 607.53%, 1443600 collisions, no waits, 237618 accesses on region 2178
* I Garbage collector tasks activated 1710 times, currently active: 0
* I CPU utilization: instance ST1: 8.2% (usr: 7.32%, sys: 0.87%), host: 20.87% (usr: 9.95%, sys: 2.08%, wio: 8.85%, idle: 776.94%)
===== #64 at 2013-11-08 09:30:55
* W1 Selects and fetches selectivity 3.05%: 2346 selects and fetches, 283035 rows read, 8635 rows qualified
* W2 1596 primary key range accesses, selectivity 0.69%: 250299 rows read, 1738 rows qualified
* W3 3 isolated index range accesses, selectivity 0.02%: 8954 rows read, 2 rows qualified
* I Garbage collector tasks activated 2070 times, currently active: 0
* I CPU utilization: instance ST1: 0.77% (usr: 0.66%, sys: 0.11%), host: 4.75% (usr: 1.55%, sys: 0.77%, wio: 2.43%, idle: 794.48%)
===== #65 at 2013-11-08 09:46:01
* W2 Selects and fetches selectivity 2.16%: 3007 selects and fetches, 353970 rows read, 7649 rows qualified
* W2 2109 primary key range accesses, selectivity 0.86%: 314423 rows read, 2707 rows qualified
* W3 9 isolated index range accesses, selectivity 0.09%: 8960 rows read, 8 rows qualified
* I Garbage collector tasks activated 2170 times, currently active: 0
* I CPU utilization: instance ST1: 0.77% (usr: 0.77%, sys: 0%), host: 3.09% (usr: 1.77%, sys: 0.55%, wio: 0.77%, idle: 795.81%)
* I Number of pages marked for reclustering: 331, clustered read operations: 29, clustered pages read: 331
===== #66 at 2013-11-08 10:01:07
* I SQL commands executed: 56691, avg. 62.44 per second
* I Garbage collector tasks activated 1620 times, currently active: 0
* I CPU utilization: instance ST1: 10.45% (usr: 10.12%, sys: 0.33%), host: 15.84% (usr: 11.66%, sys: 1.32%, wio: 2.86%, idle: 780.75%)
* I Number of pages marked for reclustering: 7, clustered read operations: 4, clustered pages read: 7
===== #67 at 2013-11-08 10:16:15
* I Garbage collector tasks activated 1480 times, currently active: 0
* I CPU utilization: instance ST1: 2.96% (usr: 2.52%, sys: 0.44%), host: 8.54% (usr: 1.75%, sys: 0.88%, wio: 5.91%, idle: 788.17%)
* I Number of pages marked for reclustering: 18, clustered read operations: 9, clustered pages read: 18
===== #68 at 2013-11-08 10:31:29
* I SQL commands executed: 6981, avg. 7.78 per second
* W2 Selects and fetches selectivity 2.04%: 6361 selects and fetches, 2167481 rows read, 44180 rows qualified
* W2 130 isolated index range accesses, selectivity 1.42%: 9081 rows read, 129 rows qualified
* I Garbage collector tasks activated 1440 times, currently active: 0
* I CPU utilization: instance ST1: 0.99% (usr: 0.88%, sys: 0.11%), host: 4.53% (usr: 2.87%, sys: 0.55%, wio: 1.1%, idle: 794.25%)
* I Number of pages marked for reclustering: 2, clustered read operations: 2, clustered pages read: 2
===== #69 at 2013-11-08 10:46:33
* I SQL commands executed: 7401, avg. 8.27 per second
* W1 Selects and fetches selectivity 4.12%: 6650 selects and fetches, 1152874 rows read, 47513 rows qualified
* W2 121 isolated index range accesses, selectivity 1.95%: 9130 rows read, 178 rows qualified
* I Garbage collector tasks activated 1900 times, currently active: 0
* I CPU utilization: instance ST1: 0.66% (usr: 0.55%, sys: 0.11%), host: 3.21% (usr: 2.1%, sys: 0.44%, wio: 0.66%, idle: 797.67%)
===== #70 at 2013-11-08 11:01:37
* I SQL commands executed: 161957, avg. 179.23 per second
* I Data cache hitrate (SQL Pages) 98.28%, 102898 of 5980539 accesses failed
* W1 Catalog cache hitrate (SQL Pages) 25.16%, 802490 of 1072211 accesses failed
* W1 Selects and fetches selectivity 2.54%: 160787 selects and fetches, 6843418 rows read, 173833 rows qualified
* W2 92 isolated index range accesses, selectivity 1.77%: 9113 rows read, 161 rows qualified
* I 1110 of 15015 read ahead requests could not be fulfilled, configured number of parallel requests (MaxDataAreaReadAheadRequests): 12
* I Garbage collector tasks activated 3070 times, currently active: 0
* I server tasks activity. Dispatches: 11572, physical reads: 13907, physical writes: 25
* W2 User task 148 processing same command since 1807s, 4 dispatches, application pid 26923
* I CPU utilization: instance ST1: 13.5% (usr: 10.84%, sys: 2.65%), host: 41.04% (usr: 13.5%, sys: 3.76%, wio: 23.78%, idle: 754.76%)
* I Number of pages marked for reclustering: 102, clustered read operations: 36, clustered pages read: 102
===== #71 at 2013-11-08 11:16:43
* I SQL commands executed: 75147, avg. 82.38 per second
* I Garbage collector tasks activated 2850 times, currently active: 0
* I CPU utilization: instance ST1: 9.75% (usr: 9.42%, sys: 0.33%), host: 16.65% (usr: 11.39%, sys: 1.31%, wio: 3.94%, idle: 780.07%)
* I Number of pages marked for reclustering: 165, clustered read operations: 49, clustered pages read: 165
===== #72 at 2013-11-08 11:31:54
* I SQL commands executed: 15207, avg. 16.67 per second
* W2 Selects and fetches selectivity 2.25%: 12182 selects and fetches, 5599929 rows read, 126003 rows qualified
* W3 Updates selectivity 0.26%: 361 updates, 166339 rows read, 425 rows qualified
* W1 10083 primary key range accesses, selectivity 3.86%: 941051 rows read, 36348 rows qualified
* W2 96 isolated index range accesses, selectivity 1.05%: 9047 rows read, 95 rows qualified
* I 20 of 302 read ahead requests could not be fulfilled, configured number of parallel requests (MaxDataAreaReadAheadRequests): 12
* I Garbage collector tasks activated 2400 times, currently active: 0
* I CPU utilization: instance ST1: 3.93% (usr: 3.49%, sys: 0.44%), host: 13.65% (usr: 3.6%, sys: 1.2%, wio: 8.84%, idle: 780.24%)
* I Number of pages marked for reclustering: 694, clustered read operations: 200, clustered pages read: 694
===== #73 at 2013-11-08 11:47:10
* W3 5 isolated index range accesses, selectivity 0.04%: 8956 rows read, 4 rows qualified
* I Garbage collector tasks activated 2050 times, currently active: 0
* I CPU utilization: instance ST1: 0.66% (usr: 0.55%, sys: 0.11%), host: 2.32% (usr: 1.1%, sys: 0.55%, wio: 0.66%, idle: 796.91%)
===== #74 at 2013-11-08 12:02:19
* I SQL commands executed: 51374, avg. 56.71 per second
* I Garbage collector tasks activated 1641 times, currently active: 0
* I CPU utilization: instance ST1: 9.04% (usr: 8.82%, sys: 0.22%), host: 14.55% (usr: 10.47%, sys: 0.99%, wio: 3.09%, idle: 782.91%)
===== #75 at 2013-11-08 12:17:23
* I Garbage collector tasks activated 1420 times, currently active: 0
* I CPU utilization: instance ST1: 0.44% (usr: 0.44%, sys: 0%), host: 2.65% (usr: 1.11%, sys: 0.55%, wio: 1%, idle: 797.12%)
===== #76 at 2013-11-08 12:32:27
* W3 3 isolated index range accesses, selectivity 0.02%: 8954 rows read, 2 rows qualified
* I 3 of 39 read ahead requests could not be fulfilled, configured number of parallel requests (MaxDataAreaReadAheadRequests): 12
* I Garbage collector tasks activated 1730 times, currently active: 0
* I CPU utilization: instance ST1: 0.99% (usr: 0.88%, sys: 0.11%), host: 3.96% (usr: 1.32%, sys: 0.66%, wio: 1.98%, idle: 794.82%)
* I Number of pages marked for reclustering: 11, clustered read operations: 5, clustered pages read: 11
Danke für die Hilfe.
MfG
Artom
