I have an app server, whose stats I can see by running 'protop asclassic1' and using the "A" command key. I view stats for the database, the app server users with 'protop myDB'. How do I view them together so I can correlate the stats?
Here are the stats for my app server in ProTop RT (protop asclassic1):
My asclassic1 is running and accessing the database, but "Blk Acc" in App Server Details is 0.
Here are the stats from the database my app server is connecting to (protop myDB):
We see 38 BlkAcc per second for Usr# 28, which is my app server client (PID 6500) running orders.p. So why aren't Blk Acc in both screens the same? Because ProTop is not connected to both resources! And yes, you can do that!
Coordinated view
To see your app server and your db activity together in one ProTop RT session, copy your app server configuration file to one that contains your database's friendlyName:
cd $PROTOP/etc
cp appsrv.asclassic1.cfg appsrv.myDB.cfg
Now, when you run 'protop myDB', protop will pull in both sets of stats. You can view both the "u" and "A" panels and see that the "Blk Acc" numbers are in sync:
NOTE: Block accesses in these screens are averages pulled two different times, so the numbers may not always match exactly, but they will be close.
This approach to viewing both resources in the same protop session provides a clearer view of the impact any given app server has on your database.