O
OctavioOlguin
Guest
I wonder, if some trained mind can take a look to this ,and perhaps to suggest if its possible to run appserver on same server as database.... 02/13/15 Activity: Summary 10:11:20 01/12/15 19:48 to 02/13/15 10:11 (758 hrs 23 min) Event Total Per Sec |Event Total Per Sec Commits 964053 0.4 |DB Reads 56352920 20.6 Undos 4810 0.0 |DB Writes 430281 0.2 Record Reads 2703175K 1013.9 |BI Reads 6305 0.0 Record Updates 1777391 0.7 |BI Writes 231204 0.1 Record Creates 585868 0.2 |AI Writes 227381 0.1 Record Deletes 32379 0.0 |Checkpoints 1886 0.0 Record Locks 25328208 9.3 |Flushed at chkpt 298136 0.1 Record Waits 1538 0.0 |Active trans 0 Rec Lock Waits 0 % BI Buf Waits 0 % AI Buf Waits 0 % Writes by APW 0 % Writes by BIW 0 % Writes by AIW 0 % DB Size: 4690 MB BI Size: 286 MB AI Size: 979 MB Empty blocks: 137098 Free blocks: 157 RM chain: 4 Buffer Hits 99 % Primary Hits 99 % Alternate Hits 0 % 15 Servers, 19 Users (0 Local, 19 Remote, 0 Batch), 0 Apws 02/13/15 Activity: Performance Indicators 10:13:24 01/12/15 19:48 to 02/13/15 10:13 (758 hrs 24 min) Total Per Min Per Sec Per Tx Commits 964068 21 0.35 1.00 Undos 4810 0 0.00 0.00 Index operations 2699423K 60746 1012.43 2867.23 Record operations 2707531K 60928 1015.47 2875.85 Total o/s i/o 57298839 1259 20.99 59.43 Total o/s reads 56409934 1240 20.66 58.51 Total o/s writes 888905 20 0.33 0.92 Background o/s writes 414615 9 0.15 0.43 Partial log writes 215378 5 0.08 0.22 Database extends 0 0 0.00 0.00 Total waits 1569 0 0.00 0.00 Lock waits 1538 0 0.00 0.00 Resource waits 31 0 0.00 0.00 Latch timeouts 77829 2 0.03 0.08 Buffer pool hit rate: 99 % Primary pool hit rate: 99 % Alternate pool hit rate: 0 % Server is Compaq Proliant 310e 16 gb ram linux 15-20 users Appserver will serve 5 users, with 4 dataset in 4 different calls by minute per user (minimum size of dataset) on peak time, 4 hours a day. After that becomes as slow as 1 dataset every 2 minutes... Currently testing on a windows desktop (but definitively, won't keep up) Any advice would be very appreciated .Thanks.
Continue reading...
Continue reading...