Kbase P63780: Promon: Monitoring I/O associated with a user process connected to a database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
04/10/2010 |
|
Status: Verified
GOAL:
How to see I/O associated with a user process connected to a database.
GOAL:
How to see which user is using a lot of disk resources via promon?
FACT(s) (Environment):
UNIX
Progress 9.x
OpenEdge 10.x
FIX:
There are several commands that can be used on UNIX to view disk I/O performance. Some of these commands are iostat, or vmstat. These commands provide an overall view of I/O for disks configured on the machine where they are invoked. For specific I/O Information per User, a Progress utility called promon can be used.
Command: promon <database name>
Will display the main menu:
PROGRESS MONITOR Version 9
Database: /tmp/dbname
1. User Control
2. Locking and Waiting Statistics
3. Block Access
4. Record Locking Table
5. Activity
6. Shared Resources
7. Database Status
8. Shut Down Database
T. Transactions Control
L. Resolve Limbo Transactions
C. Coordinator Information
M. Modify Defaults
Q. Quit
Enter your selection:
Type in "R&D" for your selection. This will bring you to the R&D menu.
Progress Version 9 Monitor (R&D)
Main (Top) Menu
1. Status Displays ...
2. Activity Displays ...
3. Other Displays ...
4. Administrative Functions ...
5. Adjust Monitor Options
Select option 3 for "Other Displays". This will display the Other Displays Menu:
Progress Version 9 Monitor (R&D)
Other Displays Menu
1. Performance Indicators
2. I/O Operations by Process
3. Lock Requests By User
4. Checkpoints
Enter a number, <return>, P, T, or X (? for help):
Select option 2 for "I/O Operations by Process". This will then present a view of I/O Operations for every user connected to the database.
Sample output:
I/O Operations by Process
-------- Database ----- ---- BI ----- ---- AI -----
Usr Name Access Read Write Read Write Read Write
1 smith 125 21 2 15 2 0 0