Trying to add AppServer to Database Server

Posted by OctavioOlguin on 13-Feb-2015 11:05

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 workgroup
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.

OpenEdge Deployment - Forum
Posted by ChUIMonster on 14-Feb-2015 12:57

You need to look at shorter samples. 758 hours isn't helpful.

I suggest Protop. http://dbappraise.com/protop.html

--
Tom Bascom
603 396 4886
tom@greenfieldtech.com

All Replies

Posted by TheMadDBA on 14-Feb-2015 11:13

The things that would prevent appservers from being run on the same box as the database would be a lack of memory or CPU.

That being said... what you describe for an appserver setup should not be a problem unless you already have serious CPU constraints.

But you should probably start looking into the _tablestat/_indexstat VSTs and your code to find out why so few users are generating so many record reads.

Posted by OctavioOlguin on 14-Feb-2015 12:49

!!!!!!  oh my.... !!!!!

I'll do that (whatever that means)

Any advice what words should I ask to some searching prompt?  Any tool I can check?

Thanks.

Posted by ChUIMonster on 14-Feb-2015 12:57

You need to look at shorter samples. 758 hours isn't helpful.

I suggest Protop. http://dbappraise.com/protop.html

--
Tom Bascom
603 396 4886
tom@greenfieldtech.com

Posted by OctavioOlguin on 14-Feb-2015 15:08

Thanks!!!

Now  I Know....

This thread is closed