Tcode DB02:DBACockpit

 

SAP Daily Monitoring Tcode DB02 : DBACockpit.

Transaction code DB02 is to analyze and monitor database statistics (DB growth, tablespace size, missing index &, etc.).

1. Check Tablespace size.

Check the Table space and growth of table space and partitioning the table.

2. Check missing indexes.

Missing indexes – Indexes which are defined in the ABAP Dictionary but are missing in the database.

3. Check Space critical objects.

Space critical objects are objects  that become space critical due to lack of insufficient free space in tablespace.