SAP/SQL Server Database Monitor

Definition

With the SAP Database Monitor for SQL Server, you can display the important parameters and performance indicators in SQL Server, such as database size, database buffer quality, and database configuration.

Use

Choose CCMS ® Control/Monitoring ® Performance Menu ® Database ® Activity. Alternatively, use transaction code ST04.

As of release 6.40 you see in the top line of every ST04 screen to which database and schema you are currently connected to. You can change this connection setting if you want to monitor any other SQL Server database in your system landscape. For more information on multi-connect and remote monitoring, see Monitoring Remote SQL Server Databases.

If you want to monitor a SQL Server database from a non-SQL Server Web Application Server, use transaction ST04_MSS instead of transaction ST04. Otherwise, you only analyze the local database.

The ST04 entrance screen is divided in the sub screens Overview and Current activity. You can switch between both sub screens using the corresponding tab-riders. The Overview sub screen contains static information although the values may change and therefore can be refreshed with the Refresh button.

The Current activity sub screen contains rather dynamic information. These values represent a floating average of the last 20 minutes (this is the default interval size that should normally not be changed).

The following functions let you see changes that occur in a short space of time:

Function

Meaning

Refresh
(Overview
sub screen)

If you press Refresh on the Overview sub screen the values of the counters will be updated. The values of the Overview sub screen reflect rather static information which will not dramatically change if you press Refresh. Some of the information, for example release information, will not change at all when pressing Refresh.

Refresh
(Current activity
sub screen)

Pressing this button will update the counter values. But these counter values rather represent dynamic values compared to the Overview sub screen values. Pressing this button will refresh the values to the latest floating average values (the floating average interval is 20 minutes as a default).

Reset
(Current activity
sub screen)

Temporarily sets the counter displays to zero.

Since Reset
(Current activity
sub screen)

Displays the delta counter values since you reset the display. You will not see the Since Reset button until you have pressed Reset.

In the menu DB Analysis of the Current activity sub screen you can also display the values since the database was started (DB Analysis ® since startup) . The values are also displayed on a per-second basis. However, keep in mind that values since startup do not really reflect the current situation on your database server!

The information on the Overview sub screen of Server Details ® Database Performance Analysis is divided into the following sections:

The top section of the Overview sub screen displays information about the database version and hardware. The DB startup field shows the date and time when SQL Server was started. You also see the number of connections to the SQL Server instance and the number of connections to the current database.

CPUs available for SQL Server is particularly important, as it shows the number of CPUs installed in the computer, and the number of CPUs used by SQL Server. The CPUs that are available for SQL Server are determined in the SQL Server configuration. See also the SQL Server option affinity mask.

The remainder of the screen is divided into the following sections:

Function

Meaning

Memory

Overview of memory configuration and performance.

Disk Space Usage

Shows disk space availability for the SAP database.

See also:

Detail Analysis Menu