Data Description
The HDB_DBCC_MTABID event is used in SAP to missing tables and indexes for the HANA DB.
Potential Use Cases
This event could be used in the following scenarios:
-
Correlate missing tables and indexes to poor SQL query performance or transaction failures.
-
Identify performance improvements after code changes move in the environment.
Splunk Event
The event will look like this in Splunk:
SAP Navigation
Execute the dbacockpit transaction in the system. Open the Diagnostics folder and double-click on “Missing Tables and Indexes”. The information displayed on the right side of the screen will match the data that is extracted and sent to Splunk.
