Storage Area views
The Storage Area Utilizations view allows you to view the status of your database storage areas. Information you find in the Storage Area view includes the percentage of use for each area, the size of each area, and an area's percentage of reads and writes relative to the monitored database's reads and writes.
Sample Storage Area Utilizations views are shown in Figure 3–8, Figure 3–9, and Figure 3–10.
Figure 3–8: Storage Area view (1 of 3)
![]()
Figure 3–9: Storage Area view (2 of 3)
![]()
Figure 3–10: Storage Area view (3 of 3)
![]()
The following information will help you interpret the data presented on the Storage Area Utilizations page:
- Reads and writes are in database blocks.
The absence of an entry in the Reads column or Writes column indicates that no reads or writes have taken place.- The percentage listed in the Reads column and Writes column is a percentage of the database's total reads or writes. For example, in Figure 3–8, the percentage of writes for the Order area accounts for 11% of the database's entire writes.
- An entry of less than one percent in the Reads column or Writes column indicates that reads or writes took place, but not enough to reach one percent.
- The Storage Area Utilization graph indicates the fullness of every storage area, while the Storage Area Relative Disk Space graph indicates the relative percent of database space used by each storage area.
- The High Water Mark (HWM) column indicates the greatest number of blocks used in a storage area. The following equation produces the percentage displayed in the HWM column: x/y, where x is the number of the HWM block and y is the total number of blocks existing in the storage area. For example, if your database's HWM block is 5 and its total number of existing blocks in the storage area is 8, the data displayed in the HWM column would be 63% (or 5/8=.625 rounded).
- The Used column indicates the amount of space used on a storage area's free chain. The following equation produces the percentage displayed in the Used column: (x-z)/y, where x is the number of the HWM block, z is the total number of free blocks in the area's extents, and y is the total number of blocks existing in the storage area.
- Double question marks in a data column indicate that the database agent could not access the needed information. See the "After Imaging areas" section for more information about double question marks.
- Double exclamation points in a data column indicate that the table was unavailable at the time the Storage Area Utilization page was built. For example, if the database agent is down and therefore unable to poll the database at the time of the view's creation, double exclamation points appear in the data columns.
System areas
The System Area section contains information about the control and schema areas. Clicking Control Area or Schema Area at the top of the Storage Area Utilizations page takes you to a more in-depth view of each. Figure 3–11 shows the Control Area page.
Note: Although it is possible to create application extents in the schema area, Fathom lists the schema area under the System Areas view. When best practices are followed and all application extents are placed in their own areas, the schema area stores only system information.Figure 3–11: Control Area view
![]()
The data presented in the Control Area and Schema Area views come from the _AreaStatus, _FileList, and _ActIOFile VSTs.
Application data areas
Names of areas listed in the Application Data section will vary according to the database being viewed. Clicking on a listed application area brings you to a more detailed view of it. In Figure 3–12, Order is the data area being viewed. Figure 3–13 shows additional information displayed in the Order Area view.
Figure 3–12: Order Area summary view
![]()
Figure 3–13: Additional Order Area view
![]()
The line charts shown in Figure 3–13 indicate reads and writes by extent.
Note: The statistical data displayed in the Table and Index Details sections are affected if the database being polled was started with the-indexrangesize
and/or the-tablerangesize
parameter. Note that both parameters have a default value of 50. If your database has 60 indexes but the-indexrangesize
parameter is set for the default, the Index Details view will only be able to display data for the first 50 indexes. When the Index Details view tries to retrieve data from the _IndexStat VST and does not find any, it will return a value of double question marks (??). See OpenEdge Deployment: Startup Command and Parameter Reference for more information about the-indexrangesize
and-tablerangesize
parameters.The application area data presented in the above view come from the _AreaStatus, _FileList, _ActIOFile, _TableStat, and _IndexStat VSTs.
Before Imaging area
The Before Imaging Area section contains information about the primary recovery area. Click Primary Recovery Area for a more detailed view, as seen in Figure 3–14.
Figure 3–14: Before Image Primary Recovery Area view
![]()
The data displayed in the BI Storage Area view come from the _AreaStatus, _FileList, and _ActIOFile VSTs.
After Imaging areas
The After Imaging Areas section contains information about any defined after image areas. Figure 3–15 shows a sample AI Storage Area view.
Figure 3–15: After Image Storage Area view
![]()
Because only one
AI
area can be active at a time, additional listedAI
areas will have some data columns populated by two question marks. See Figure 3–8 for an example of this.The data displayed in the AI Storage Area view come from the _AreaStatus, _FileList, and _ActIOFile VSTs.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |