Show TOC

Procedure documentationDatabase Console Locate this document in the navigation structure

 

The Tools contains a display of the information for runtime analysis of database system bottlenecks detected when using the database tool XCONS (database console).

Procedure

  1. Open the Database Assistant (transaction code DB50) or the liveCache Assistant (transaction code LC10). Choose   Tools   Database Console/Console  . For SAP liveCache, you also have the option of going directly to the Console from the initial screen of the liveCache Assistant.

    The database console display is part of the DBA Cockpit and can therefore also be called as follows:

    1. Open DBA Cockpit (transaction DBACOCKPIT).

    2. The display options in DBA Cockpit vary depending on which SAP NetWeaver release you are using:

      • Choose   Diagnosis   Database Console  .

      • SAP NetWeaver 7.1: Choose   Tools   Database Console  .

  2. Select the required command. There are commands available for obtaining information from a wide range of different areas, for example, disk accesses, process analysis or memory management.

  3. Choose   Database Console   Execute Command  .

Result

The required information is retrieved from the database console and immediately displayed on the screen. You can save the results as a local file.

SYSMON Tables

If the database instance is in the operational state ONLINE, you can display the SYSMON tables. To do so, choose   Goto   SYSMON Table Display  .

Example Example

Displaying information about critical sections:

To do this, choose   Goto   SYSMON Table Display  . Enter table name SYSMON_REGION.

End of the example.

More Information