Monitoring the SAP Data Disk
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 comesto a standstill. Although, after the installation of the SAP system, the autogrow option is set and files automatically grow whenever they are full, this still does not guarantee that disks do 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.
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, see
Changing the Size of
the Database Files.
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 see Monitoring 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 DBACOCKPIT 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.