SAP/SQL Server Database Monitor (SAP Library - Technical Operations Manual for mySAP Technology)

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.

Choose CCMS ® Control/Monitoring ® Performance Menu ® 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.
Absolute Values/Relative Values	Toggles the values in the SQL Requests and Server Engine sections

The information on the main screen of Server Details ® 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 SAP database.
Server Engine	Shows CPU consumption and disk I/O.
SQL Requests	Overview of SQL Server request statistics.