Monitoring Databases in a Database Landscape

Database landscapes are used for managing multiple database computers (servers).

Prerequisites

In Database Studio, you are logged on to the databases that you want to monitor.

Procedure

Opening the Databases Monitor

In the explorer tree, go to the top level using the (Up One Level) button.
Select the database landscape that you want to monitor.
In the context menu of the database landscape, choose Databases Monitor.

Adding or Removing Columns

Next to (Editor Menu), open the dropdown menu.
Choose Columns...
Select or deselect columns.

Database Properties (In Alphabetical Order)
Property	Description	More Information
Automatic Log Backup	Shows whether automatic log backup has been activated.	Activating or Deactivating Automatic Log Backup
Build	Build number of the software version of the installation to which the database belongs
Data Area	Fill level of the data area	Displaying Information About the Data Area
Data Cache Hit Rate	The data cache hit rate shows whether the data cache has been configured sufficiently large. The lower the hit rate, the poorer your system's performance. Recommendation Data cache hit rate > 99% End of the recommendation.	Concepts of the Database System, Working Memory Areas
Database Name	Database Name
Database Server	Name of the database computer
Dependent Path	For software version <7.8: Dependent path
Global Data Path	Global data path	Glossary, Directory
Global Program Path	Global programs path	Glossary, Directory
Independent Data Path	For software version <7.8: Independent data path
Independent Program Path	For software version <7.8: Independent program path
Installation Path	Installation path	Glossary, Directory
Kernel	Kernel variant	Glossary, Kernel Variant
Last Refresh	Last refresh of the information about the database
Log Area	Information about the overwrite mode or the filling level of the log area	Displaying Information About the Log Area
Name	`<computer_name>:<database_name>`
Next Refresh	Next refresh of the information about the database
Operating System	Operating system of the database computer
Operational State	Operational state of the database	Starting or Stopping Databases
Private Data Path	Private data path	Glossary, Directory
Refresh Interval	Refresh interval for the information about the database
Run Directory Path	The run directory of a database is the directory where the database system saves the configuration and log files of the database.	Glossary, Run Directory
Sessions	Database sessions Note If no more database sessions are free, no more database users can log on to the database. To configure the number of available sessions, change the general database parameter `MaxUserTasks`. End of the note.	Changing Database Parameters
Started On	Time and date of the last database start
User Name	Name of the user with which Database Studio is currently connected to the database (login)
Status	Number of warnings
Version	Software version of the installation to which the database belongs

Sorting by Warning Level

Add the Status column.
Click the Status column header.

Changing the Properties of the Databases Monitor

Next to (Editor Menu), open the dropdown menu.
Choose Properties...

Specify your properties.

Databases Monitor: Properties
Property	Description
Refresh interval	Specifies how often the status information for the databases is refreshed (in seconds)
Maximum number of threads to use	Only relevant for large database landscapes Maximum number of threads that the system uses to update the status of the individual databases
Restore databases monitor on startup	To open the Databases Monitor after starting Database Studio, select this option.

Changing the Refresh Interval for Individual Databases

In Databases Monitor, choose Properties in the context menu of the database.
Change the refresh interval.

More Information

Managing Database Landscapes