G
grupoci
Guest
Hi, recently we change our databases to a new server but the startup and the queries are extremely slow, even tho the hardware is better than before. We lack knowledge about databases, we manage our clients services and remote connection as well as other services but we do not know about databases, we cannot diagnose and fix the performance issues, so we thought you guys could help us. The virtual machine specifications are: Windows 2012 x64, Xeon E5-2620 v3 2,40Ghz, two processors, and 17Gb Ram. We currently use OpenEdge 11.1 x32 This are the startup log of the DB: BROKER 0: (333) Login multi-user. BROKER 0: (15321) Log Initialization Before Image in block 758, offset 964. BROKER 0: (452) The SYSTEM user logs in batch. BROKER 0: (5644) to 2509 using TCP Arrancado IPV4 address 0.0.0.0, pid 364. BROKER 0: (8836) Connecting to the Admin Server on port 7842. BROKER 0: (14262) Successfully connected to AdminServer on port 7842 using TCP / IP IPV4 address 192,168,150,254. BROKER 0: (8846) Registered with the Admin Server. BROKER 0: (4234) Release Progress OpenEdge 11.1 build 1143 in WINNT. BROKER 0: (4281) initiated by SYSTEM on Server batch. BROKER 0: (6574) Booted using pid: 364. BROKER 0: (4235) Physical name of the database (-db): C: \ SYNERGY \ Active \ BDCemevisa \ ver2000. BROKER 0: (4236) Database type (-dt): PROGRESS. BROKER 0: (4237) Forced access (-F): Not Enabled. BROKER 0: (4238) Direct I / S (-directio): Not Enabled. BROKER 0: (-----) enabled LRU mechanism. BROKER 0: (-----) Number of LRU force skips (-lruskips): 0 BROKER 0: (-----) Number of LRU2 force skips (-lru2skips): 0 BROKER 0: (4239) Number of Buffers Database (-B): 390000. BROKER 0: (-----) Number of Alternate Database Buffers (-B2): 0. BROKER 0: (9422) Max number of private buffers by to list it (-Bpmax): 256. BROKER 0: (4240) has exceeded the size of shared memory (-Mxs): 100. BROKER 0: (10013) The shared memory segment is locked into memory. BROKER 0: (4241) Current size of the lock table (L): 819200. BROKER 0: (13953) Number of maximum area (-maxArea): 32000. BROKER 0: (4242) Table Entries Hash (-hash): 32. BROKER 0: (4243) Current attempts Spin Locks (-spin): 80000. BROKER 0: (6526) Number semaphore set (-semsets) 3. BROKER 0: (13924) Maximum size of shared memory segment (-shmsegsize) 4096 Mb. BROKER 0: (4244) Crash Recovery (-i): Enabled. BROKER 0: (6573) Database Blocksize (-blocksize): 4,096. BROKER 0: (4245) Delayed flow-Picture Previous (-mf): 2. BROKER 0: (4247) E / S in file-Picture Previous (-r -R): Reliable. BROKER 0: (4249) truncation Range Image-anteror (-G): 0. BROKER 0: (4250) Cluster size Image-Previous: 524288. BROKER 0: (4251) Block Size Image-Previous: 8192. BROKER 0: (4252) Number of buffers IMAGE-Previous (-bibufs): 90. BROKER 0: (-----) Record free chain search depth factor of 5 (-recspacesearchdepth) BROKER 0: (9238) File Size Threshold of BI (-bithold): 999.5 MBytes. [BROKER 0: (6551) File Stall Threshold BI (-bistall): Enabled. BROKER 0: (4254) Since IMAGE-Posterior (-aistall): Enabled. BROKER 0: (4255) Block Size Image-Posterior: 8192. BROKER 0: (4256) Number of buffers IMAGE-Posterior (-aibufs): 40. ROKER 0: (-----) Partition Manager cache size (-mtpmsize): 1024 BROKER 0: (8527) cache size storage object (-omsize): 8192 BROKER 0: (4257) Maximum number of clients per server (Ma): 2. BROKER 0: (4258) Maximum number of servers (-Mn): 26. BROKER 0: (4259) Minimum number of clients per server (My): 1. BROKER 0: (-----) Server network message wait time (-Nmsgwait): 2 BROKER 0: (-----) Delay first prefetch message (-prefetchDelay): Disabled BROKER 0: (-----) Prefetch message fill percentage (-prefetchFactor): 0 BROKER 0: (-----) Minimum records in prefetch msg (-prefetchNumRecs): 16 BROKER 0: (-----) Suspension poll queue priority (-prefetchPriority): 0 BROKER 0: (4260) Maximum number of users (n): 61. BROKER 0: (4261) Host Name (H): bData. BROKER 0: (4262) Name Service (-S): 2509. BROKER 0: (14268) version of TCP / IP (-ipver): IPV4 BROKER 0: (4263) Network type (N): TCP. BROKER 0: (4264) Character Set (-cpinternal): ISO8859-1. BROKER 0: (4282) Parameter File: Not Enabled. BROKER 0: (5647) Limit broker servers (-Mpb): 23. BROKER 0: (5648) Minimum Port for Auto Servers (-minport): 3000. BROKER 0: (5649) Maximum Port for Auto Servers (-maxport): 5000. BROKER 0: (8863) This broker only supports groups 4GL servers. BROKER 0: (9336) Created with the shared memory segment id: 43057152 BROKER 0: (12813) allowed Cursors index (c): 244. BROKER 0: (12814) Group Delay (-groupdelay): 10. BROKER 0: (12815) Block hash table, table size (-lkhash): 137,743 BROKER 0: (12816) Maxport (-maxport): 5000 BROKER 0: (12817) Minport (-minport): 3000 BROKER 0: (12818) Message Buffer Size (Mm): 32600 BROKER 0: (12820) Servers highs Broker (-Mpb): 23 BROKER 0: (12821) Use muxlatches (-mux): 1 BROKER 0: (12823) Traffic lights (-semsets): 3 BROKER 0: (13870) Database Service Manager - Queue Size IPC (-pica): 8.0 MBytes. BROKER 0: (13896) Limit jump TXE lock Commit (-TXESkipLimit): 10000. BROKER 0: (15219) encryption is enabled: 0 BROKER 0: (15218) cache size encryption (-ecsize): 1000 BROKER 0: (15824) Multi-tenancy enabled: 0 BROKER 0: (10471) Database Have Been enabled connections. SRV 1: (452) The SYSTEM user logs in batch. BROKER 1: (5644) 2500 Arrancado using TCP IPV4 address 0.0.0.0, pid 3272. BROKER 1: (5645) This is an additional broker for this protocol. BROKER 1: (8864) This broker only supports SQL server groups. SRV 2: (452) The user logs on SYSTEM WITH :. SRV 2: (5646) Booted in IPV4 TCP port 3001 using address 0.0.0.0, pid SRV 2: (742) connecting the user number 85, userid client manager type ABL, in bData using TCP / IP IPV4 address 192,168,150,254. SRV 2: (7129) 85 Usr set to administrator name. We also had a shared memory overflow-size issue, as shown in the startup log. Yet we do not fully understand the problem, since it has been set to 1024 and we still have that problem. Also, we have around 60 clients, which values should B1 and B2 be at? Right now, the database queries takes the entire CPU % usage, which is not normal. I really appreciate your help guys.
Continue reading...
Continue reading...
