Critical File Resource statistics displayed in SirMon: Difference between revisions
Jump to navigation
Jump to search
m (minor formatting) |
m (mention RKWeb equivalents) |
||
Line 3: | Line 3: | ||
Each of the critical file resources protects the integrity of a | Each of the critical file resources protects the integrity of a | ||
<var class="product">Model 204</var> file structure. | <var class="product">Model 204</var> file structure. | ||
Critical file resource statistics are provided by <var class="product">SirMon</var> to assist | Critical file resource statistics are provided by <var class="product">SirMon</var> to assist | ||
in diagnosing second order performance problems. | in diagnosing second order performance problems. | ||
Keep in mind that the resources themselves are not what | Keep in mind that the resources themselves are not what | ||
is being viewed, but the activity that is occurring against them. | is being viewed, but the activity that is occurring against them. | ||
In RKWeb, you can display both file and user critical file resource statistics by selecting Performance > Custom from the Monitor tab, then clicking <b>Files</b> or <b>Users</b> along with the <b>Critical File Resource</b> drop-down menu item. | |||
<table class="thJustBold"> | <table class="thJustBold"> |
Revision as of 19:49, 16 May 2017
Critical File Resource statistics describe activity which is occurring
against the four critical file resources: DIRECT
, INDEX
, EXISTS
, and RECENQ
.
Each of the critical file resources protects the integrity of a
Model 204 file structure.
Critical file resource statistics are provided by SirMon to assist in diagnosing second order performance problems. Keep in mind that the resources themselves are not what is being viewed, but the activity that is occurring against them.
In RKWeb, you can display both file and user critical file resource statistics by selecting Performance > Custom from the Monitor tab, then clicking Files or Users along with the Critical File Resource drop-down menu item.
BUFPAGE | Total number of pages in the disk buffer pool currently occupied by pages from all tables in the database file. Equal to BUFPAGA+BUFPAGB+BUFPAGC+BUFPAGD+BUFPAGF . |
---|---|
CFRCDIR | Conflicts on the DIRECT critical file resource (rate or total). This resource protects the integrity of Table B. |
CFRCEXS | Conflicts on the EXISTS critical file resource. This resource protects the integrity of the existence bit map. |
CFRCIND | Conflicts on the INDEX critical file resource. This resource protects the integrity of the database indexes. |
CFRCREC | Conflicts on the RECENQ critical file resource. This resource protects the integrity of the record enqueueing tables. |
CFRQDIR | Number of users waiting for the DIRECT critical file resource. This resource protects the integrity of table B. |
CFRQEXS | Number of users waiting for the EXISTS critical file resource. This resource protects the integrity of the existence bit map. |
CFRQIND | Number of users waiting for the INDEX critical file resource. This resource protects the integrity of the database indexes. |
CFRQREC | Number of users waiting for the RECENQ critical file resource. This resource protects the integrity of the record enqueuing tables. |
CFRQUEU | Number of users waiting for any critical file resource. |
DKRD | Physical page reads from a Model204 database file or CCATEMP. |
DKWR | Physical page writes to a Model 204 database file or CCATEMP. |
HDDIRCT | Type of enqueue on the critical file resource that protects the Table B records (EXC , SHR , or blank). |
HDEXIST | Type of enqueue on the critical file resource that protects the existence bit map (EXC , SHR , or blank). |
HDINDEX | Type of enqueue on the critical file resource that protects the Table C and D indexes (EXC , SHR , or blank). |
HDRECNQ | Type of enqueue on the critical file resource that protects existence bit map pages for locked record sets (EXC , SHR , or blank). |
PNAME | Name of the currently executing or last executed procedure. |
See also
- SirMon
- SirMon application structure
- SirMon main menu
- SirMon System Overview screen
- SirMon threshold setting
- SirMon background monitor
- SirMon System Monitor menu
- SirMon User Monitor menu
- SirMon File Monitor menu
- SirMon Subsystem Monitor menu
- SirMon Task Monitor menu
- SirMon Janus Monitor menu
- SirMon custom screens
- SirMon critical-file-resource monitoring
- SirMon user-initiated capturing of statistics
- System statistics displayed in SirMon
- User statistics displayed in SirMon
- File statistics displayed in SirMon
- Subsystem statistics displayed in SirMon
- Task statistics displayed in SirMon
- Critical File Resource statistics displayed in SirMon
- SirMon date processing