Generate DBAnalys Output (!)

Generate DBAnalys Output (!)


This option generates a DB analysis and saves it to the $PROTOP/dbanalys directory so that it can be used by both ProTop RT and the ProTop Monitoring agents (commercial version of ProTop).

Insight into DB Analysis

DB analysis data provides important contextual information in ProTop: should you be concerned if a table is read 1000 times per second throughout the day? That depends...if it's the country table with approximately 200 entries, then maybe...probably. There could be an opportunity for code improvement or you could assign the country table to the alternate buffer pool (see the Churn column in Table Activity (t)).

Selecting "<Help>" Ignore if visible (only visible with OpenEdge development license)