S
Stefan Marquardt
Guest
Windows 2008R2 Every area has only one open extent, there are other larger extents. I redo the same test procedure again and again, today my fault was to set -B to 200000, 185000 works. Wed Oct 15 14:02:57 2014 [2014/10/15@14:02:57.149+0200] P-21776 T-44116 I BROKER 0: (333) Multi-user session begin. [2014/10/15@14:02:57.208+0200] P-21776 T-44116 I BROKER 0: (5326) Begin Physical Redo Phase at 2048 . [2014/10/15@14:02:59.967+0200] P-21776 T-44116 I BROKER 0: (7161) Physical Redo Phase Completed at blk 2644 off 6668 upd 7626. [2014/10/15@14:02:59.969+0200] P-21776 T-44116 I BROKER 0: (13547) At end of Physical redo, transaction table size is 256. [2014/10/15@14:03:00.153+0200] P-21776 T-44116 I BROKER 0: (452) Login by winsure on batch. [2014/10/15@14:03:00.187+0200] P-21776 T-44116 I BROKER 0: (5644) Started for 21600 using tcp IPV4 address 0.0.0.0, pid 21776. [2014/10/15@14:03:00.188+0200] P-21776 T-44116 I BROKER 0: (4234) Progress OpenEdge Release 10.2B build 1907 SP08 on WINNT . [2014/10/15@14:03:00.189+0200] P-21776 T-44116 I BROKER 0: (4281) Server started by winsure on batch. [2014/10/15@14:03:00.189+0200] P-21776 T-44116 I BROKER 0: (-----) Started using pid: 21776. [2014/10/15@14:03:00.190+0200] P-21776 T-44116 I BROKER 0: (4235) Physical Database Name (-db): C:\ProgramData\Progress\eNoraAcc\winsureuk\sure_db\winsure. [2014/10/15@14:03:00.192+0200] P-21776 T-44116 I BROKER 0: (4236) Database Type (-dt): PROGRESS. [2014/10/15@14:03:00.193+0200] P-21776 T-44116 I BROKER 0: (4237) Force Access (-F): Not Enabled. [2014/10/15@14:03:00.193+0200] P-21776 T-44116 I BROKER 0: (4238) Direct I/O (-directio): Not Enabled. [2014/10/15@14:03:00.194+0200] P-21776 T-44116 I BROKER 0: (-----) LRU mechanism enabled. [2014/10/15@14:03:00.194+0200] P-21776 T-44116 I BROKER 0: (-----) Number of LRU force skips (-lruskips): 0 [2014/10/15@14:03:00.195+0200] P-21776 T-44116 I BROKER 0: (-----) Number of LRU2 force skips (-lru2skips): 0 [2014/10/15@14:03:00.195+0200] P-21776 T-44116 I BROKER 0: (4239) Number of Database Buffers (-B): 50000. [2014/10/15@14:03:00.196+0200] P-21776 T-44116 I BROKER 0: (-----) Number of Alternate Database Buffers (-B2): 0. [2014/10/15@14:03:00.196+0200] P-21776 T-44116 I BROKER 0: (9422) Maximum private buffers per user (-Bpmax): 64. [2014/10/15@14:03:00.196+0200] P-21776 T-44116 I BROKER 0: (4240) Excess Shared Memory Size (-Mxs): 35. [2014/10/15@14:03:00.197+0200] P-21776 T-44116 I BROKER 0: (10014) The shared memory segment is not locked in memory. [2014/10/15@14:03:00.198+0200] P-21776 T-44116 I BROKER 0: (4241) Current Size of Lock Table (-L): 80000. [2014/10/15@14:03:00.199+0200] P-21776 T-44116 I BROKER 0: (13953) Maximum Area Number (-maxArea): 32000. [2014/10/15@14:03:00.199+0200] P-21776 T-44116 I BROKER 0: (4242) Hash Table Entries (-hash): 13063. [2014/10/15@14:03:00.200+0200] P-21776 T-44116 I BROKER 0: (4243) Current Spin Lock Tries (-spin): 2000. [2014/10/15@14:03:00.200+0200] P-21776 T-44116 I BROKER 0: (6526) Number of Semaphore Sets (-semsets): 3. [2014/10/15@14:03:00.200+0200] P-21776 T-44116 I BROKER 0: (13924) Maximum Shared Memory Segment Size (-shmsegsize) 512 Mb. [2014/10/15@14:03:00.201+0200] P-21776 T-44116 I BROKER 0: (4244) Crash Recovery (-i): Enabled. [2014/10/15@14:03:00.201+0200] P-21776 T-44116 I BROKER 0: (6573) Database Blocksize (-blocksize): 8192. [2014/10/15@14:03:00.201+0200] P-21776 T-44116 I BROKER 0: (4245) Delay of Before-Image Flush (-Mf): 3. [2014/10/15@14:03:00.202+0200] P-21776 T-44116 I BROKER 0: (4247) Before-Image File I/O (-r -R): Reliable. [2014/10/15@14:03:00.274+0200] P-21776 T-44116 I BROKER 0: (4249) Before-Image Truncate Interval (-G): 0. [2014/10/15@14:03:00.275+0200] P-21776 T-44116 I BROKER 0: (4250) Before-Image Cluster Size: 8388608. [2014/10/15@14:03:00.275+0200] P-21776 T-44116 I BROKER 0: (4251) Before-Image Block Size: 16384. [2014/10/15@14:03:00.276+0200] P-21776 T-44116 I BROKER 0: (4252) Number of Before-Image Buffers (-bibufs): 20. [2014/10/15@14:03:00.276+0200] P-21776 T-44116 I BROKER 0: (-----) Record free chain search depth factor 5 (-recspacesearchdepth) [2014/10/15@14:03:00.277+0200] P-21776 T-44116 I BROKER 0: (9238) BI File Threshold size (-bithold): 0.0 Bytes. [2014/10/15@14:03:00.278+0200] P-21776 T-44116 I BROKER 0: (6552) BI File Threshold Stall (-bistall): Disabled. [2014/10/15@14:03:00.278+0200] P-21776 T-44116 I BROKER 0: (4254) After-Image Stall (-aistall): Not Enabled. [2014/10/15@14:03:00.278+0200] P-21776 T-44116 I BROKER 0: (4255) After-Image Block Size: 8192. [2014/10/15@14:03:00.279+0200] P-21776 T-44116 I BROKER 0: (4256) Number of After-Image Buffers (-aibufs): 20. [2014/10/15@14:03:00.279+0200] P-21776 T-44116 I BROKER 0: (8527) Storage object cache size (-omsize): 1024 [2014/10/15@14:03:00.279+0200] P-21776 T-44116 I BROKER 0: (4257) Maximum Number of Clients Per Server (-Ma): 10. [2014/10/15@14:03:00.280+0200] P-21776 T-44116 I BROKER 0: (4258) Maximum Number of Servers (-Mn): 7. [2014/10/15@14:03:00.280+0200] P-21776 T-44116 I BROKER 0: (4259) Minimum Clients Per Server (-Mi): 10. [2014/10/15@14:03:00.280+0200] P-21776 T-44116 I BROKER 0: (-----) Server network message wait time (-Nmsgwait): 2 [2014/10/15@14:03:00.281+0200] P-21776 T-44116 I BROKER 0: (-----) Use pollset mechanism for client/server (-pollset): Disabled [2014/10/15@14:03:00.281+0200] P-21776 T-44116 I BROKER 0: (-----) Delay first prefetch message (-prefetchDelay): Disabled [2014/10/15@14:03:00.281+0200] P-21776 T-44116 I BROKER 0: (-----) Prefetch message fill percentage (-prefetchFactor): 0 [2014/10/15@14:03:00.282+0200] P-21776 T-44116 I BROKER 0: (-----) Minimum records in prefetch ms (-prefetchNumRecs): 16 [2014/10/15@14:03:00.282+0200] P-21776 T-44116 I BROKER 0: (-----) Suspension queue poll priority (-prefetchPriority): 0 [2014/10/15@14:03:00.282+0200] P-21776 T-44116 I BROKER 0: (4260) Maximum Number of Users (-n): 61. [2014/10/15@14:03:00.283+0200] P-21776 T-44116 I BROKER 0: (4261) Host Name (-H): DEXW4160. [2014/10/15@14:03:00.283+0200] P-21776 T-44116 I BROKER 0: (4262) Service Name (-S): 21600. [2014/10/15@14:03:00.284+0200] P-21776 T-44116 I BROKER 0: (14268) TCP/IP Version (-ipver) : IPV4 [2014/10/15@14:03:00.285+0200] P-21776 T-44116 I BROKER 0: (4263) Network Type (-N): tcp. [2014/10/15@14:03:00.285+0200] P-21776 T-44116 I BROKER 0: (4264) Character Set (-cpinternal): ISO8859-1. [2014/10/15@14:03:00.285+0200] P-21776 T-44116 I BROKER 0: (4282) Parameter File: \\dexw4160\C$\ProgramData\Progress\eNoraAcc\winsureuk\swinsureN.pf. [2014/10/15@14:03:00.286+0200] P-21776 T-44116 I BROKER 0: (5648) Minimum Port for Auto Servers (-minport): 3000. [2014/10/15@14:03:00.286+0200] P-21776 T-44116 I BROKER 0: (5649) Maximum Port for Auto Servers (-maxport): 5000. [2014/10/15@14:03:00.286+0200] P-21776 T-44116 I BROKER 0: (8865) This broker supports both 4GL and SQL server groups. [2014/10/15@14:03:00.287+0200] P-21776 T-44116 I BROKER 0: (9426) Large database file access has been enabled. [2014/10/15@14:03:00.288+0200] P-21776 T-44116 I BROKER 0: (9336) Created shared memory with segment_id: 39780352 [2014/10/15@14:03:00.289+0200] P-21776 T-44116 I BROKER 0: (12813) Allowed index cursors (-c): 244. [2014/10/15@14:03:00.289+0200] P-21776 T-44116 I BROKER 0: (12814) Group delay (-groupdelay): 10. [2014/10/15@14:03:00.290+0200] P-21776 T-44116 I BROKER 0: (12815) Lock table hash table size (-lkhash): 13063 [2014/10/15@14:03:00.290+0200] P-21776 T-44116 I BROKER 0: (12816) Maxport (-maxport): 5000 [2014/10/15@14:03:12.261+0200] P-21776 T-44116 I BROKER 0: (12817) Minport (-minport): 3000 [2014/10/15@14:03:12.262+0200] P-21776 T-44116 I BROKER 0: (12818) Message Buffer Size (-Mm): 1024 [2014/10/15@14:03:12.262+0200] P-21776 T-44116 I BROKER 0: (12821) Use muxlatches (-mux): 1 [2014/10/15@14:03:12.263+0200] P-21776 T-44116 I BROKER 0: (12823) Semaphore Sets (-semsets): 3 [2014/10/15@14:03:12.263+0200] P-21776 T-44116 I BROKER 0: (13870) Database Service Manager - IPC Queue Size (-pica) : 64.0 KBytes. [2014/10/15@14:03:12.264+0200] P-21776 T-44116 I BROKER 0: (13896) TXE Commit lock skip limit (-TXESkipLimit): 10000. [2014/10/15@14:03:12.264+0200] P-21776 T-44116 I BROKER 0: (15219) Encryption enabled: 0 [2014/10/15@14:03:12.265+0200] P-21776 T-44116 I BROKER 0: (15218) Encryption cache size (-ecsize): 1000 [2014/10/15@14:03:12.336+0200] P-97908 T-34728 I APPSRV 7: (452) Login by winsure on batch. [2014/10/15@14:03:12.361+0200] P-21776 T-44116 I BROKER 0: (10471) Database connections have been enabled.
Continue reading...
Continue reading...