D
durgaprasad m
Guest
Hi, We are experiencing high memory usage for our Progress Red Hat Enterprise Linux Server release 6.6. Progress version : 11.4 Yesterday server team has increased memory from 40gb to 50gb but no database changes has been made on that time.But once server restarted and database were backup up after that memory was showing 37gb memory.used out of 5ogb. At 8PM online backup has happened after that server has used all memory and 100% swap memory. what are the things we have to check from server level and database side. The following factors can affect server performance: • Disk I/O relating to database, before-image I/O • Record locking • Memory usage • Database and index fragmentation For example: Before increasing memory size if we kill all the process related to database and application process it will work ? Kindly provide your suggestions. FYI.............. free total used f ree shared buffers cached Mem: 51496052 50346340 1149712 31566472 255540 43489644 -/+ buffers/cache: 6601156 44894896 Swap: 2098172 132092 1966080 top - 18:04:54 up 1 day, 12 min, 3 users, load average: 0.01, 0.09, 0.29 Tasks: 323 total, 1 running, 322 sleeping, 0 stopped, 0 zombie Cpu(s): 0.2%us, 0.1%sy, 0.0%ni, 99.5%id, 0.2%wa, 0.0%hi, 0.0%si, 0.0%st Mem: 51496052k total, 50205340k used, 1290712k free, 265012k buffers Swap: 2098172k total, 132092k used, 1966080k free, 43492228k cached Thanks..........
Continue reading...
Continue reading...