Show TOC

Monitoring BWA IndexesLocate this document in the navigation structure

Use

In addition to being able to monitor BW Accelerator (see Monitoring SAP BW Accelerator), you can also use BW Accelerator Monitor (transaction RSDDBIAMON2) to monitor BWA indexes.

Note

Note that you cannot manage and maintain BWA indexes in BW Accelerator Monitor.

Task

Procedure

Description

Check BWA indexes for performance and consistency

Choose Start of the navigation path BW Accelerator Next navigation step Index Checks Next navigation step Execute/Display /Index Checks End of the navigation path.

You can get the system to run the following checks once a day (at 0:00:01) and show you the results:

  • Check size of delta indexes for BWA indexes

  • Compare size of InfoCube fact table with fact index

  • Check: Table index relation

    You can still define the number of random queries for the consistency check.

    These checks provide important information for performance and consistency. They can be found in the analysis and repair environment (see Tests for BWA Indexes in Transaction RSRV).

    If you do not want to run these checks regularly, you can choose Index Checks Deschedule and specify that the system should not schedule the checks.

Check BWA Index Settings

Choose Start of the navigation path BW Accelerator Next navigation step Index Settings End of the navigation path.

You can call the following functions:

  • Change Global Parameters: See Maintaining Global BWA Index Settings.

  • Switching On the Delta Index For information about optimizing the performance of frequently used BW Accelerator indexes, see Improving Efficiency Using BWA Delta Indexes.

  • Switch BWA Indexes for Queries On/Off: The Switch BIA Indexes for Queries On/Off dialog appears. If you do not want the BWA index to be available for one or more BW objects for Reporting, select the relevant flag in the Switched Off for Queries/F4 Help column.

Display BWA Indexes

Choose Start of the navigation path BW Accelerator Next navigation step Index Information Next navigation step Display All BWA Indexes End of the navigation path.

All existing BWA indexes are displayed

For a detailed description of BWA indexes and the displayed functions and parameters, see Displaying a SAP BW Accelerator Index.

Monitor Master Data Delta Indexing

Choose Start of the navigation path BW Accelerator Next navigation step Index Information Next navigation step Log: Master Data Delta Indexing End of the navigation path..

The system logs the results of the regular master data delta indexing process. It records which characteristics new attributes have been written to which index tables for from BWA.