R/3 Static Database Monitor (MS SQL Server) 

Use

The R/3 Static Database Monitor displays information about the current status of the database. In addition it offers a number of functions that execute checks or return detailed information about the database.

Prerequisites

To access the R/3 Static Database Monitor, enter the transaction code DB02.

Features

The initial screen of the monitor displays information on the status of the database grouped in four different categories: Database System, Database, Files, and Tables Indexes, Stored Procedures. The date and time when the information was generated is shown at the top of the screen. A Refresh button is provided to update the information.

Information on the Initial Screen

Screen Area

Information

Database System

Name of the database and the time when the information on the screen were generated

Database

Space analysis for the R/3 database and transaction logs

Files

Lists the files of the R/3 database, their location and size and other data.

Tables, Indexes, Stored Procedures

Specifies how many of these exist in the system and their size.

Options

Pushbutton

Function

DB Space history

Displays the history of space usage in the system distinguishing between space allocated to tables and space allocated to indexes.

DB analysis

Offers a number of options to execute checks on the database.

Detail Analysis

Executes a consistency check for a specified table and returns detailed information about the table.

 

See also:

Checking Consistency of Individual Tables

Checking for Missing Indexes

Database Management Tools

R/3 SQL Server Database Monitor