Data Description

The MSS_DB02_IOPF event is used in SAP to view input/output (IO) operations for database storage.

Potential Use Cases

This event could be used in the following scenarios:

  • Alert on potential performance impacts to the database.

  • Dashboard I/O speeds over time for the database storage.

Splunk Event

The event will look like this in Splunk:

SAP Navigation

Log into the managed system and execute the dbacockpit transaction code. Expand the Performance menu option on the left side of the screen and double-click I/O peformance. The information displayed will match the data that is extracted and sent to Splunk.

Field Mapping

Field

Description

Unit of Measure

 BYTESREAD

Number of bytes returned from ::fn_virtualfilestats

Number

BYTESWTN

Number of bytes written from ::fn_virtualfilestats

Number

CURRENT_TIMESTAMP

The date time stamp when the information was collected

YYYYMMDDHHMMSS

DBNAME

Database name

String

EVENT_SUBTYPE

String

EVENT_TYPE

MSS_DB02_IOPF

String

FILENAME

Logical file name

String

FILETYPE

MS SQL Server file type

String

IOSTALLMS

IO stall ms per read + write operation

Number

IOSTALLRDMS

IO Stall - milliseconds / read request

Number

IOSTALLWRMS

IO Stall - milliseconds / write request

Number

KBREADREQ

kilobytes read per request

Number

KBREADSEC

kilobytes read per second

Number

KBWRTREQ

kilobytes written per request

Number

KBWRTSEC

kilobytes written per second

Number

LOGFILENA

Logical file name

String

NUMREADS

Number of reads per second

Number

NUMWRITES

Number of writes returned from ::fn_virtualfilestats

Number

PARTITION

MS SQL Server partition name

String

UTCDIFF

The UTC OFFSSET in HHMMSS that the data was collected in

HHMMSS

UTCSIGN

The UTC positive or negative OFFSET indicator. Positive (+) means add UTCDIFF to find the time zone of the data, negative (-) means subtract the UTCDIFF to find the time zone adjusted date time the data was collected in.

+ | -