HDB_DBCC_ACTSTM
Data Description
The HDB_DBCC_ACTSTM event is used in SAP to view active SQL statements running in the HANA database. This data is extracted in a snapshot view, meaning that the SQL running at the time of extraction is collected.
Potential Use Cases
This event could be used in the following scenarios:
View a snapshot of SQL statements running in the HANA database at a given time.
Visualize SQL statement execution time.
Identify lock waits associated with the SQL statement.
Splunk Event
The event will look like this in Splunk:
![](../__attachments/3294199847/image-20220713-204057.png?inst-v=cc5d1456-4022-4264-b658-e73cfc9f0416)
SAP Navigation
Execute the dbacockpit transaction in the system. Open the Performance folder and double-click on “Active Statements”. The data displayed on the right side of the screen will match the data that is extracted and sent to Splunk.
![](../__attachments/3294199847/image-20220713-204430.png?inst-v=cc5d1456-4022-4264-b658-e73cfc9f0416)