Data Description

The MSS_DB02_STMT event is used in SAP to view SQL statements for a Microsoft SQL database.

Potential Use Cases

This event could be used in the following scenarios:

  • Identify problematic SQL statements in the environment.

  • Correlate application performance to SQL statements.

  • Create alerts for poor performing SQL statements.

Splunk Event

The event will look like this in Splunk:

SAP Navigation

Log into the managed system and execute the dbacockpit transaction code. Then expand the Performance menu option, and double click the SQL Statements section. The data displayed on the page will match the data that is extracted and sent to Splunk.