Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

Using the BI Accelerator Monitor

Use

The BI accelerator monitor is used for the technical administration and maintenance of the BI accelerator. It provides an overview of the current status of the BI accelerator.

The BI accelerator monitor displays the results of the consistency checks. These checks run periodically on the BI accelerator. If problems occur, the system automatically proposes appropriate actions. These actions involve BI accelerator repair functions which can be used to fix problems.

To estimate the status of the BI accelerator quickly, there is a quick overview function for the BI accelerator monitor that summarizes the most important check results.

The detailed BI accelerator monitor offers a detailed, technical overview of the hardware, BI accelerator services, any trace files that exist and the BI accelerator indexes.

In the BI accelerator monitor, it is not possible to maintain the indexes on the logical level of the BI accelerator InfoProvider. Use BI accelerator index maintenance instead.

Queries work with the accelerator component of the BI accelerator, the BI accelerator monitor works with the alert server. The accelerator components and the alert server are independent services within the BI accelerator. For this reason, queries can run without errors while at the same time, the BI accelerator monitor displays an error on the alert server.

Integration

Access from Data Warehousing Workbench

You are in the Administration functional area of the Data Warehousing Workbench. In the navigation pane, choose Monitors -> BI Accelerator Monitor. The quick overview of the BI accelerator monitor appears.

Access from Transaction RSDDV

You have called the BIA index maintenance wizard for the InfoCube. In the dialog box for the BIA index maintenance wizard, choose BIA Monitor. The quick overview of the BI accelerator monitor appears.

Prerequisites

The BI accelerator is based on TREX technology.

Features

BIA Results of Check Screen Area

Test Results area

Here the system displays the results of the BI accelerator consistency checks.


Tab Page


Description


Summary


The start view shows a summary of the current results of the check.
The system tries to summarize the current results of the check in such a way that, where necessary, it can repair the status of the BI accelerator in as few actions as possible.
The status display differentiates:
if the status is ok
if there are messages or warnings
if there are errors for the status
With status and , the system usually displays an action that can fix the problem. If the proposed action can be started from the BI system, you initiate this action by choosing in the Execute column.
For each action, the user can display an explanatory long text by choosing (Display Long Text).
If details are available for a check, the user can call them by choosing (Details Available) in the Details column. The system displays the appropriate details in the Check Details screen area.


Current Results


This view displays the current results of the consistency checks that were performed.
The status of the checks are indicated by the colors , or .
The system displays general information about each check: the length of the check (in seconds), date and time at which the check was started, the check set within which the check was started.
For each check, the user can display an explanatory long text in the Long Text column by choosing (Display Long Text).
If a check determines that an action is required to solve the problem identified, the system displays the action in the table. If applicable, you start the action by choosing in the!s_b_exec.gif! Execute column. Choose to display an explanatory long text.
If details are available for a check, the user can call them by choosing (Details Available) in the Details column. The system displays the appropriate details in the Check Details screen area.


History


This view returns the results of previous check runs for the BI accelerator consistency checks so that you can track developments or changes in the results.
The system displays general information about each check: the length of the check (in seconds), date and time at which the check was started, the check set within which the check was started.
For each check, the user can display an explanatory long text in the Long Text column by choosing (Display Long Text).
Since this information is not current, the system does not propose actions.

Check Details area

If more details are available for the check result, the user can display these details here.

If problems are listed with BI accelerator servers, you can display the affected servers in the details area.

BIA Actions Screen Area

Execute Actions area

In the Execute Actions screen area, the user can execute the most important actions directly to fix BI accelerator problems. The BI accelerator differentiates between actions that the user can start from the BI system and those that the user must carry out in the BI accelerator.

Example of an action that the user must carry out in the BI accelerator: Actions for the trace files of the BI accelerator.

On the Current Results tab page in the Check Results screen area, the BI accelerator proposes actions for check results that have status  or . If these are actions that can be executed from the BI system, you can execute them directly by choosing .

In the Execute Actions screen area, the BI accelerator monitor collects all the proposed actions. It sets the indicator if the action can be started from the BI system. A Proposal field is displayed alongside the proposed actions.

Here the system supports the direct execution of the following actions:


Action


Description


Restart host


This action restarts the BI accelerator hardware.


Restart BIA server


This action restarts all the BI accelerator servers and services. This includes the name server and index server.


Restart BIA index server


This action only restarts the index server. (The name servers are not restarted.)


Rebuild BIA indexes


If a check discovers inconsistencies in the indexes, you can use this action to delete and rebuild all the BI accelerator indexes.


Reorganize BIA landscape


If the BI accelerator server landscape is unevenly distributed, this action redistributes the loaded indexes on the BI accelerator servers.

The actions Restart Host, Restart BIA Server, and Restart BIA Index Server are hierarchically related: If the host is automatically restarted the server is automatically restarted so that this action no longer has to be started explicitly. For example, the Restart BIA Server action includes a restart of the BIA index server. Therefore, as soon as a higher-level option is selected, the system automatically sets the indicator for the lower-level selection boxes and deactivates them in the selection.

BIA Action Messages area

The log display in the BIA Action Messages screen area shows information about the processes in the BI accelerator monitor.

If the system reads status information (gets check results), it writes this to the log, for example: Status Information Read from BIA.

Each message has a status (,,) and where appropriate, the option of displaying the explanatory long text by choosing .

The Detail Level is usually one, unless the messages are structured hierarchically.

Choose (Refresh Messages) to refresh the log display.

Choose (Delete Messages) to delete the messages in the log.

Toolbar Functions

The following functions are available in the toolbar:


Function


Description


(Refresh BIA Log and Actions)


Refreshes the monitor.
The system displays the current results of the BI accelerator checks again and determines new proposals for actions.


BIA Availability


Uses an RFC availability test to check the availability of the connection to the BI accelerator. If no connection to the BI accelerator is available, necessary measures are initiated, where appropriate.


 Switch On BIA Load Monitor or Switch Off BIA-Load Monitor 


Calls the BI accelerator load monitor in a separate window that refreshes itself independently.
In this window, you can see the following BI accelerator key figures:
Host:Port: Host and port of the BI accelerator
Memory Process: Memory usage of TREX server process
Total Memory: Memory usage of all processes
Memory Available: Available memory
CPU of All Processes: CPU usage of all processes
CPU Process: CPU usage of TREX server processes
Response Time: Average response time of the last queries
Queries: Queries per second
Requests: Number of external requests
Requests Including Internal: Number of external and internal requests
Requests Active: Number of active requests
Hanging Requests: Number of hanging requests
You can only start one load monitor.
Since the load monitor is started in a new window, it uses a new mode. Make sure that you have a free mode before you activate the load monitor.
For technical reasons, the load monitor window is kept open. If it is covered by other windows, you can access it using the key combination ALT+TAB. You can continue to work in this window or close it.
You can only end the load monitor from the BI accelerator monitor: As soon as you start the load monitor, the pushbutton function changes to Switch Off BIA Load Monitor. After you have stopped the load monitor, the system resets the mode to the start view.

Menu Goto

You can choose the following options from the Goto menu:


Menu Option


Meaning


Analysis of BI Objects


The Analysis and Repair of BI Objects screen appears. 


BIA Index Maintenance


The Maintaining Aggregates/BIA Index: Select InfoCube screen appears (transaction RSDDV).


TREX Administration Tool


The TREX Administration Tool screen appears.

Menu BI Accelerator

You can choose the following options from the BI Accelerator menu:


Menu Option


Meaning


Execute Action


You start required actions directly from the BI system (see BIA Actions screen area above).


Switch On BIA Load Monitor or Switch Off BIA Load Monitor 


You call the load monitor of the BI accelerator in a separate window (see Toolbar Functions above).


Index Checks


The Execute/Display Index Checks option allows you to determine that the system execute the following checks once a day (always at 0:00:01) and then displays the results:
?         Check size of delta indexes for BIA indexes
?         Compare size of InfoCube fact table with fact index
?         Find indexes with status "unknown"
?         Check: Table index relation 
These checks are quick to run and provide important information about performance and consistency. They can be found in the analysis and repair environment.
If you do not want to run these checks regularly, you can choose the Schedule Index Checks option from the menu and specify that the system does not schedule the checks. 


Index Information


You can call the following functions from this menu option:
?         Change Global Parameters
?         Display All BIA Indexes
?         Set Delta Index:  
?         Switch BIA Indexes for Queries On/Off


Invalidate Dimension Function Indexes


The system builds a dimension function index (DFI) when a query is executed. It contains data for the JOIN between two (or more) indexes. You can reuse a DFI for similar queries or similar JOINS.
This menu option in the BI accelerator monitor allows you to delete all the DFIs in the system.
If you only want to deactivate the DFI for one particular query, you can execute the query in the query monitor (transaction RSRT1) with the debug option Do Not Use BIA Dimension Function Index.

Activities

You get detailed information about the status of the BI accelerator and the check results.

The system proposes actions to correct errors in the BI accelerator, if applicable.

If these actions can be started in the BI system, you can trigger them there immediately.

  • No labels