G
George Potemkin
Guest
02/20/19 Activity: Buffer Cache 00:30:23 02/20/19 00:25 to 02/20/19 00:30 (5 min 1 sec) Total Per Min Per Sec Per Tx Primary Buffer Pool Logical reads 18978066 3783003 63050.05 979.41 Logical writes 3635 725 12.08 0.19 O/S reads 2900533 578179 9636.32 149.69 O/S writes 44 9 0.15 0.00 Writes deferred 3600 718 11.96 0.19 LRU skips 5592058K 1114696K 19024144.18 295518.78 LRU writes 44 9 0.15 0.00 APW enqueues 0 0 0.00 0.00 Active Blocks 3998028 796949 13282.49 206.33 Master Blocks 1 0 0.00 0.00 Index Blocks 26 5 0.09 0.00 Record Blocks 3997946 796933 13282.21 206.32 Sequence Blocks 1 0 0.00 0.00 Object Blocks 54 11 0.18 0.00 Primary buffer pool hit ratio: 84 % Alternate Buffer Pool Logical reads 21437394 4273235 71220.58 1106.33 Logical writes 12025 2397 39.95 0.62 O/S reads 50411 10049 167.48 2.60 O/S writes 7835 1562 26.03 0.40 Writes deferred 11510 2294 38.24 0.59 LRU2 skips 9 2 0.03 0.00 LRU2 writes 0 0 0.00 0.00 APW enqueues 9 2 0.03 0.00 Active Blocks 1000003 199336 3322.27 51.61 Master Blocks 0 0 0.00 0.00 Index Blocks 999851 199306 3321.76 51.60 Free Blocks 44 9 0.15 0.00 Object Blocks 108 22 0.36 0.01 Alternate buffer pool hit ratio: 99 % LRU2 replacement policy enabled. Activity seems to be stayed the same for a long time.
Continue reading...
Continue reading...
