S
Stefan Marquardt
Guest
I reduced the APWs too: Hit% 97.90 Commits: 12,424 New RM: 10,778 Oldest TRX: 00:00:00 Connections: 12 Log Reads: 35,990 Undos: 0 From RM: 10,777 Curr BIClstr: 4,280 Brokers: 1 OS Reads: 755 Lock Tbl HWM: 388 From Free: 1 Oldest BIClstr: 4,280 4gl Servers: 1 Rec Reads: 12,428 Curr # Locks: 3 Examined: 11,114 Checkpoints: 4,279 SQL Servers: 0 LogRd/RecRd: 2.90 Modified Bufs: 2,097 Front2Bk: 0 Curr AI Extent: Disabled 4gl Clients: 5 Log Writes: 45,440 IO Response: 4.77 Remove Lk: 0 Curr AI Seq#: 0 SQL Clients: 0 OS Writes: 1,110 BogoMIPS: 4.17 Empty AI Exts: -1 App Server: 1 Rec Creates: 0 BogoMIP%: 91.67 Full AI Exts: -1 BIW: 1 Rec Updates: 12,425 AIW: 0 Rec Deletes: 0 Notes: 70,289 0 APW Writes: 751 APWs: 2 Rec Locks: 24,851 BIW/AIW Write% 88 0 APW Write% 68 WDOG: 1 Rec Waits: 0 Writes to Log: 1,487 0 Bufs Scanned: 96 Local: 1 Idx Blk Spl: 0 BIW/AIW Writes: 1,307 0 APW Scan Wrts: 1 Remote: 1 Resrc Waits: 39 Partial Buf Wr: 1 0 APW Q Wrts: 0 Batch: 4 Latch Waits: 3 Busy Buf Waits: 38 0 Chkpt Q Wrts: 750 TRX: 1 Empty Buf Wts: 202 0 Flushed Bufs: 4 Blocked: 0
Continue reading...
Continue reading...