Show TOC

HistoryLocate this document in the navigation structure

Use

This section provides information about Database Size History and Table Size History.

Database Size History

This screen displaysthe database size, allocated space and other detailed information about the database.

In the DBA Cockpit choose Start of the navigation path Space Next navigation step History  Next navigation step Database Size History End of the navigation path.

You can display data for the whole database in either daily, weekly, or monthly statistics. You can also display data in the same periods for one or all data files of the SAP database.

Table Size History

This screen displays detailed information about the sizing and space consumption of each of the tables in the SAP database.

In the DBA Cockpit choose Start of the navigation path Space Next navigation step History  Next navigation step Table Size History End of the navigation path.

By default, the 300 largest tables are shown but can be changed if required. To view the detailed size history for an individual table, select a table and click on the Table Size History button.

An SQL Server Agent job called SAP CCMS_<schema>_<db>_Update_Tabstats collects the data for the table size history.