B
bremmeyr
Guest
♀11/21/17 Activity: Summary 11:41:12 11/21/17 11:41 to 11/21/17 11:41 (10 sec) Event Total Per Sec |Event Total Per Sec Commits 17 1.7 |DB Reads 220 22.0 Undos 0 0.0 |DB Writes 0 0.0 Record Reads 398316 39831.6 |BI Reads 0 0.0 Record Updates 17 1.7 |BI Writes 3 0.3 Record Creates 0 0.0 |AI Writes 3 0.3 Record Deletes 0 0.0 |Checkpoints 0 0.0 Record Locks 51 5.1 |Flushed at chkpt 0 0.0 Record Waits 0 0.0 |Active trans 0 Rec Lock Waits 0 % BI Buf Waits 0 % AI Buf Waits 0 % Writes by APW 0 % Writes by BIW 0 % Writes by AIW 0 % DB Size: 14 GB BI Size: 1263 MB AI Size: 1456 K Empty blocks: 91385 Free blocks: 41426 RM chain: 2832 Buffer Hits 99 % Primary Hits 99 % Alternate Hits 0 % 8 Servers, 22 Users (4 Local, 18 Remote, 8 Batch), 0 Apws ♀11/21/17 Activity: Performance Indicators 11:42:35 11/21/17 11:41 to 11/21/17 11:41 (10 sec) Total Per Min Per Sec Per Tx Commits 17 102 1.70 1.00 Undos 0 0 0.00 0.00 Index operations 389515 2337090 38951.50 22912.65 Record operations 398333 2389998 39833.30 23431.35 Total o/s i/o 226 1356 22.60 13.29 Total o/s reads 220 1320 22.00 12.94 Total o/s writes 6 36 0.60 0.35 Background o/s writes 6 36 0.60 0.35 Partial log writes 6 36 0.60 0.35 Database extends 0 0 0.00 0.00 Total waits 0 0 0.00 0.00 Lock waits 0 0 0.00 0.00 Resource waits 0 0 0.00 0.00 Latch timeouts 1888 11328 188.80 111.06 Buffer pool hit rate: 99 % Primary pool hit rate: 99 % Alternate pool hit rate: 0 % ♀11/21/17 Activity: Latch Counts 11:43:29 11/21/17 11:41 to 11/21/17 11:41 (10 sec) ----- Locks ----- ------ Busy ------ Naps - --------- Spins ----------- ----- Nap Max ----- Owner Total /Sec /Sec Pct /Sec / Sec /Lock /Busy Total HWM MTX -- 71 7 0 0.0 0 0 0 0 0 0 USR -- 45 4 0 0.0 0 0 0 0 0 0 OM -- 466061 46606 0 0.0 36 0 0 0 0 0 BIB -- 60 6 0 0.0 0 0 0 0 0 0 SCH -- 0 0 0 0.0 0 0 0 0 0 0 LKP -- 0 0 0 0.0 0 0 0 0 0 0 GST -- 0 0 0 0.0 0 0 0 0 0 0 TXT -- 68 6 0 0.0 0 0 0 0 0 0 LKT -- 72 7 0 0.0 0 0 0 0 0 0 LKT -- 43 4 0 0.0 0 0 0 0 0 0 LKT -- 74 7 0 0.0 0 0 0 0 0 0 LKT -- 32 3 0 0.0 0 0 0 0 0 0 SEQ -- 0 0 0 0.0 0 0 0 0 0 0 AIB -- 60 6 0 0.0 0 0 0 0 0 0 TXQ -- 70 7 0 0.0 0 0 0 0 0 0 Enter for more, A, L, R, S, U, Z, P, T, or X (? for help): ♀11/21/17 Activity: Latch Counts 11:43:31 11/21/17 11:41 to 11/21/17 11:41 (10 sec) ----- Locks ----- ------ Busy ------ Naps - --------- Spins ----------- ----- Nap Max ----- Owner Total /Sec /Sec Pct /Sec / Sec /Lock /Busy Total HWM EC -- 0 0 0 0.0 0 0 0 0 0 0 LKF -- 68 6 0 0.0 0 0 0 0 0 0 BFP -- 0 0 0 0.0 0 0 0 0 0 0 BHT -- 906599 90659 0 0.0 0 0 0 0 0 0 PWQ -- 0 0 0 0.0 0 0 0 0 0 0 CPQ -- 0 0 0 0.0 0 0 0 0 0 0 LRU -- 906403 90640 0 0.0 148 0 0 0 0 0 LRU -- 0 0 0 0.0 0 0 0 0 0 0 BUF -- 447032 44703 0 0.0 2 0 0 0 0 0 BUF -- 451183 45118 0 0.0 0 0 0 0 0 0 BUF -- 401535 40153 0 0.0 0 0 0 0 0 0 BUF -- 514389 51438 0 0.0 0 0 0 0 0 0 INC -- 0 0 0 0.0 0 0 0 0 0 0 L29 -- 0 0 0 0.0 0 0 0 0 0 0 L30 -- 0 0 0 0.0 0 0 0 0 0 0 L31 -- 0 0 0 0.0 0 0 0 0 0 0 ♀11/21/17 Status: Servers 11:44:19 Sv Pend. Cur. Max. Port No Pid Type Protocol Logins Users Users Users Num 0 5484 Login TCP 0 0 0 2 2021 1 16956 Auto TCP 1 0 1 2 4002 2 7256 Login TCP 20343 0 0 6 2020 3 8132 Auto TCP 2091 4 2 6 4100 4 6276 Auto TCP 3764 4 2 6 4101 5 6116 Auto TCP 2128 4 2 6 4102 6 18496 Auto TCP 790 0 1 2 4006 7 4848 Auto TCP 6079 2 4 6 4103 8 8424 Auto TCP 2067 3 2 6 4104 9 7772 Auto TCP 2069 5 0 6 4105 10 7472 Auto TCP 2120 3 2 6 4106 11 13372 Auto TCP 105 0 1 2 4003 12 14000 Auto TCP 600 0 1 2 4004 13 17196 Auto TCP 461 0 0 2 4005
Continue reading...
Continue reading...
