Kbase P25289: Script to monitor database peformance
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/7/2009 |
|
Status: Verified
GOAL:
Sample script to monitor database performance
GOAL:
Example of VST database performance monitoring through a cron job
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
FIX:
# VST.p
DEF STREAM s.
find first _actbuffer no-lock no-error.
find first _actsummary no-lock no-error.
find first _actrecord no-lock no-error.
find first _actbilog no-lock no-error.
find first _actindex no-lock no-error.
find first _actiotype no-lock no-error.
OUTPUT STREAM s TO ./vst.txt APPEND.
PUT STREAM s UNFORMATTED STRING(TODAY, "99.99.9999") " " STRING(TIME, "HH:MM:SS") " ".
PUT STREAM s UNFORMATTED _actbuffer._Buffer-Flushed " " _actbuffer._Buffer-LogicRds " " _actbuffer._Buffer-LogicWrts " " _actbuffer._Buffer-OSRds " " _actbuffer._Buffer-OSWrts " ".
PUT STREAM s UNFORMATTED _actsummary._Summary-DbReads " " _actsummary._Summary-DbWrites " " _actsummary._Summary-Commits " "_actsummary._Summary-DbAccesses.
PUT STREAM s UNFORMATTED _actrecord._Record-RecRead " " _actrecord._Record-RecUpd " " _actrecord._Record-RecCreat " " _actrecord._Record-RecDel.
PUT STREAM s UNFORMATTED _actbilog._BiLog-TotalWrts " " _actbilog._BiLog-BIWWrites.
PUT STREAM s UNFORMATTED _actindex._index-create " " _actindex._index-delete " " _actindex._index-find _actindex._index-free " " _actindex._index-remove " " _actindex._index-splits.
PUT STREAM s UNFORMATTED _actiotype._IOType-DataReads " " _actiotype._IOType-IdxRds " " _actiotype._IOType-IdxWrts.
PUT STREAM s UNFORMATTED SKIP.
OUTPUT STREAM s CLOSE.
QUIT.