C
ctoman
Guest
The seeks are in the Trillions on the OS. Database is stuck in the mud. 03/30/17 Activity: Performance Indicators 09:16:56 03/30/17 01:19 to 03/30/17 09:16 (7 hrs 57 min) Total Per Min Per Sec Per Tx Commits 5780127 12118 201.96 1.00 Undos 1328 3 0.05 0.00 Index operations 363992K 781401 13023.35 64.48 Record operations 365505K 784649 13077.48 64.75 Total o/s i/o 39118266 82009 1366.82 6.77 Total o/s reads 38425583 80557 1342.61 6.65 Total o/s writes 692683 1452 24.20 0.12 Background o/s writes 661377 1387 23.11 0.11 Partial log writes 130309 273 4.55 0.02 Database extends 0 0 0.00 0.00 Total waits 3801361 7969 132.82 0.66 Lock waits 1740590 3649 60.82 0.30 Resource waits 2060771 4320 72.00 0.36 Latch timeouts 783780 1643 27.39 0.14 Buffer pool hit rate: 95 % 03/30/17 Checkpoints 09:16:56 Ckpt ------ Database Writes ------ No. Time Len Dirty CPT Q Scan APW Q Flushes 257 09:16:38 0 2921 1084 12 0 0 36 18 1093 256 09:15:58 40 3008 2982 33 19 0 100 37 3005 255 09:14:55 63 1561 736 62 732 19 100 63 1520 254 09:14:10 45 1684 643 175 1530 41 100 45 1639 253 09:12:55 75 1648 532 188 1579 0 100 69 1642 252 09:12:01 54 1914 978 66 1304 0 100 50 1911 251 09:11:05 56 2312 1077 93 1193 0 100 55 2309 250 09:10:28 37 2333 1752 38 556 0 100 36 2330 03/30/17 Activity: Resource Queues 09:16:56 03/30/17 01:19 to 03/30/17 09:16 (7 hrs 57 min) Queue - Requests - ------- Waits ------- --- Wait usec --- Total /Sec Total /Sec Pct /Req /Wait Shared Memory 0 0 0 0 0.00 0 0 Record Lock 54839828 1916 1740590 61 0.03 0 0 Schema Lock 0 0 0 0 0.00 0 0 Trans Commit 548941 19 0 0 0.00 0 0 DB Buf I Lock 4994617 175 9 0 0.00 0 0 Record Get 325100000 11359 3 0 0.00 0 0 DB Buf Read 38415876 1342 0 0 0.00 0 0 DB Buf Write 497898 17 0 0 0.00 0 0 DB Buf Backup 0 0 0 0 0.00 0 0 DB Buf S Lock 951151168 33234 2044399 71 0.00 0 0 DB Buf X Lock 5415413 189 1532 0 0.00 0 0 DB Buf Avail 0 0 0 0 0.00 0 0 Lock 12 0 0 0 0 0.00 0 0 BI Buf Read 7083 0 0 0 0.00 0 0 BI Buf Write 123407 4 2427 0 0.02 0 0 AI Buf Read 1194 0 0 0 0.00 0 0 AI Buf Write 71353 2 50 0 0.00 0 0 Lock 17 0 0 0 0 0.00 0 0 TXE Share Lock 5143269 180 0 0 0.00 0 0 TXE Update Lock 1290896 45 3188 0 0.00 0 0 TXE Commit Lock 269174 9 9163 0 0.03 0 0 TXE Excl Lock 0 0 0 0 0.00 0 0 Lock 22 0 0 0 0 0.00 0 0 03/30/17 Activity: TXE Lock Activity 09:16:56 03/30/17 01:19 to 03/30/17 09:16 (7 hrs 57 min) --- Requests ---- --------- Waits --------- Total /Sec Total /Sec Pct Record Create 661634 23 0 0 0.00 Record Modify 1803081 63 47 0 0.00 Record Delete 544334 19 1206 0 0.22 Key Add 1898452 66 0 0 0.00 Key Delete 1413880 49 1896 0 0.13 Sequence Update 0 0 0 0 0.00 Other 112784 3 39 0 0.03 Share Locks 5143269 179 0 0 0.00 Update Locks 1290896 45 3188 0 0.25 Commit Locks 269174 9 9163 0 3.40 Excl Locks 0 0 0 0 0.00 Total 6703339 234 12351 0 0.18 Upgrades Request: 197621 Rate: 6 Pct: 3.84 Current Share: 1 Update: 0 Commit: 0 Excl: 0 Current Wait: 0 Wait: 0 Wait: 0 Wait: 0 03/30/17 Activity: Latch Counts 09:16:56 03/30/17 01:19 to 03/30/17 09:16 (7 hrs 57 min) --- Locks --- --- Busy --- Naps ------ Spins ------- Owner Total /Sec /Sec Pct /Sec /Sec /Lock /Busy MTX -- 21147005 738 0 0.0 2 0 0 0 USR -- 2783603 97 0 0.0 0 0 0 0 OM -- 470309825 16432 0 0.0 1 0 0 0 BIB -- 11081439 387 0 0.0 0 0 0 0 SCH -- 43005398 1502 0 0.0 0 0 0 0 LKP -- 1211865 42 0 0.0 0 0 0 0 GST -- 180361 6 0 0.0 0 0 0 0 TXT -- 18053957 630 0 0.0 0 0 0 0 LKT -- 0 0 0 0.0 2 0 0 0 SEQ -- 4 0 0 0.0 0 0 0 0 AIB -- 11066532 386 0 0.0 0 0 0 0 TXQ -- 13214361 461 0 0.0 0 0 0 0 BIW -- 0 0 0 0.0 0 0 0 0 LKF -- 746975573 26099 0 0.0 1 0 0 0 BFP -- 4 0 0 0.0 0 0 0 0 BHT -- 1002465439 35026 0 0.0 6 0 0 0 PWQ -- 498637 17 0 0.0 0 0 0 0 AIW -- 0 0 0 0.0 0 0 0 0 CPQ -- 1991368 69 0 0.0 0 0 0 0 LRU -- 962031243 33613 0 0.0 8 0 0 0 LRU -- 0 0 0 0.0 0 0 0 0 LRU -- 0 0 0 0.0 0 0 0 0 LRU -- 0 0 0 0.0 0 0 0 0 BUF -- 0 0 0 0.0 1 0 0 0 BUF -- 0 0 0 0.0 1 0 0 0 BUF -- 0 0 0 0.0 1 0 0 0 BUF -- 0 0 0 0.0 1 0 0 0 L28 -- 0 0 0 0.0 0 0 0 0 L29 -- 0 0 0 0.0 0 0 0 0 L30 -- 0 0 0 0.0 0 0 0 0 L31 -- 0 0 0 0.0 0 0 0 0
Continue reading...
Continue reading...
