The MSS_DB02_OVFL event is used in SAP to view the size of specific database files for a Microsoft SQL database.
Potential Use Cases
This event could be used in the following scenarios:
Dashboard storage use over time.
Alert when specific files on the database are filling.
The event will look like this in Splunk:
Log into the managed system and execute the dbacockpit transaction code. Then expand the Space menu option on the left side of the screen and double-click the Overview option. Then click on Files tab that appears in the center of the screen. The information shown will match the data that is extracted and sent to Splunk.
Unit of Measure
ALERT Status , 'R','Y','G' - red,yellow,green
Allocated space in a DB file in MB
The date time stamp when the information was collected
Free space left on file system (partition) in MB.
FILE ID of DB file for SQL Server
MSS Alert Text as seen in RZ20
File size limit in MB configured in SQL Server.
File size in MB.
Free percentage of space in a SQL Server file
File growth step configured in SQL Server.
True file growth in MB
SQL Server file has growth represented in percentage
file is a log file
Logical file name
Physical file name (full path) of the database file.
Primary file containing startup information and also data
The file group is read only
The UTC OFFSSET in HHMMSS that the data was collected in
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.
+ | -