SAP/SQL Server Database Monitor (SAP Library

SAP/SQL Server Database Monitor

Definition

With the R/3 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.

Choose Tools ® Administration ® Monitor ® Performance ® Database ® Activity. Alternatively, use transaction code ST04.

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

Reset	Temporarily sets the displays in the Server Engine/Elapsed and SQL Requests sections to zero.
Since Reset	Displays the values in the Server Engine/Elapsed and SQL Requests sections since you reset the display.
Refresh	Returns the main screen to the current values.
Totals per Second/Absolute Totals	Toggles the values in the Server Engine/Elapsed and SQL Requests sections

The information on the main screen Database Performance Analysis is divided into the following sections:

The top section of the screen displays information about the database version and hardware. The DB startup field shows the date and time when SQL Server was started. Your analysis of the information in the Database Monitor is only meaningful if the database has been running for several hours with a typical database workload.

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:

Memory Usage	Overview of memory configuration and performance.
Space Usage	Shows disk space availability for the R/3 database.
Server Engine/Elapsed	Shows CPU consumption and disk I/O.
SQL Requests	Overview of SQL Server request statistics.