Storage Area Utilizations view

The Storage Area Utilizations view allows you to view the status of your database storage areas. Information you find in the 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–7, Figure 3–8, and Figure 3–9.

Figure 3–7: Storage Area Utilizations view (1 of 3)

Figure 3–8: Storage Area Utilizations view (2 of 3)

Figure 3–9: Storage Area Utilizations view (3 of 3)

The following information will help you interpret the data presented on the Storage Area Utilizations page:

System areas

The System areas section contains information about the Control Area and the Schema Area. Clicking either the Control Area or the Schema Area at the top of the Storage Area Utilizations page takes you to a more in-depth view of each one. Figure 3–10 shows the Control Area page.

Note: Although it is possible to create application extents in the schema area, OpenEdge Management shows the schema area in the System area 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–10: 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 areas 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–11, Order is the data area being viewed. Figure 3–12 shows additional information displayed in the Order Area view.

Figure 3–11: Order Area summary view

Figure 3–12: Additional Order Area view

The line charts shown in Figure 3–12 indicate writes and reads by extent.

Note: The statistical data displayed in the Table Details 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 areas

The Before Imaging areas section contains information about the primary recovery area. Click Primary Recovery Area for a more detailed view, as seen in Figure 3–13.

Figure 3–13: 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–14 shows a sample AI Storage Area view.

Figure 3–14: After Image Storage Area view

Because only one AI area can be active at a time, additional listed AI areas will have some data columns populated by two question marks. See Figure 3–7 for an example of this.

The data displayed in the AI Storage Area view come from the _AreaStatus, _FileList, and _ActIOFile VSTs.


Copyright © 2008 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095