Show TOC

Monitoring the SAP Data DiskLocate this document in the navigation structure

Use

It is vital to regularly check the space used by the server. If the data file or log file of the database is full, the SAPsystem will come to a standstill. Although, the autogrow option is set after the installation of the SAPsystem, and files automatically grow whenever they are full, this still does not guarantee that disks will not run out of space. Checking the amount of free space available on the disk must always be one of the routine tasks performed by a database administrator.

Note

SAP recommends that the database administrator manually grow the database files during periods of low database activity. When files auto grow it can be very performance intensive for the system and SAP users and programs may be affected. It is best to monitor the files weekly and manually increase the file size during periods of low activity.

For more information about changing the database files sizes, seeChanging the Size of the Database Files

Note

When you look at the amount of free space specified for logs, keep in mind that the data displayed reflects snapshots taken at a specific point in time. Depending on your backup strategy, logs might be backed up and truncated at hourly intervals. As a result, a large amount of free space might be displayed because the log has just been truncated. For more information, seeMonitoring the SAP Log Disk.

Procedure

Monitoring the Current Database Size

Use the following procedure in the SQL Server Management Studio, to get a quick overview of the current size of the database files and the free space available.

  1. In the SQL Server Management Studio, expand the server and Databases.
  2. Right-click the <SAPSID> database and choose Properties.

    On the right-hand pane, you can see the database size and available space.

Monitoring the Database Size History

Use this procedure to get an overview of the space used by the SAP database over a longer period of time.

  1. Go to the DBA Cockpit with transaction DBACOCKPIT and navigate to Space → History →Database Size History.
  2. Use the available pushbuttons to change the period for which you want to view space history.