Data Description
The MSS_DB02_PERF event is used in SAP to view overall database performance for a Microsoft SQL database.
Potential Use Cases
This event could be used in the following scenarios:
Correlate database performance statistics with events in the application layer.
Alert on potential databsae problems.
Trend database performance statistics over time.
Splunk Event
The event will look like this in Splunk:
...
SAP Navigation
Log into the managed system and execute the dbacockpit transaction code. Then go to the Performance menu on the left side of the screen and expand the options, and double-click the Overview section.
...
The information from the Overview tab will match the data extracted and sent to Splunk.
...
Field Mapping
Field | Description | Unit of Measure |
|---|---|---|
ANALYSISDATE | Date when analysis data was read | YYYYMMSS |
ANALYSISTIME | Time when analysis data was read | HHMMSS |
BUFHITRATIO | Datacache hit ratio | Number |
BUFPGLOOKUPS | Number of buffer page lookups per batch | Number |
BUFPGWAITMS | Wait time to read a page into buffer | Number |
CACHEHITRATIO | Procedure cache hit ratio | Number |
CACHESZ | Size of whole SQL Server procedure cache | Number |
COLUMNSTORESZ | Column store memory size in MB | Number |
CPUBUSY | SQL Server CPU busy counter | Number |
CPUIDLE | SQL Server CPU idle counter | Number |
CPUINFO | CPU information (number of CPUs used) | Ratio (String) |
CURRENT_TIMESTAMP | The date time stamp when the information was collected | YYYYMMDDHHMMSS |
CURRMEM | Currently used SQL Server memory | Number |
DATABUFFERSZ | Datacache size in MB | Number |
DBCONNECTS | Number of Connections to current database | Number |
DBFREE | Free space in database in MB | Number |
DBSTRTDATE | Date when SQL Server was started | YYYYMMSS |
DBSTRTTIME | Time when SQL Server was started | HHMMSS |
EVENT_SUBTYPE | String | |
EVENT_TYPE | MSS_DB02_PERF | String |
FO_MESSAGE | Failover type description (Mirrored/AlwaysOn,etc) | String |
FO_TYPE | Natural NumberFailover type | Number |
FREEPGSZ | Free pages in MB | Number |
FULLSCANS | Number of full scans per second | Number |
IDXSEARCHES | Number of index searches per second | Number |
IOBUSY | SQL Server IO busy counter | Number |
IOSTALLREAD | IOStall per read request | Number |
IOSTALLWRITE | IOStall per read request | Number |
ISAWE | Single-Character Indicator | Boolean |
ISCLUSTER | Is SQL Server clustered 'Y' or 'N' | Boolean |
ISPAE | Single-Character Indicator | Boolean |
LAZYWRITES | Lazy writes (per second) | Number |
LOCKMEM | SQL Server Memory currently used for locking | Number |
LOGFLUSHES | Number of log flushes | Number |
LOGFLUSHWAITMS | Wait time per log flush | Number |
LOGFREE | Free log space in MB | Number |
LOGWRITEWAITMS | Wait time per log write request | Number |
MACHINETYPE | Machine Type | Sting |
MAXMEM | Max memory limit for SQL Server | Number |
MEMOPT | Memory options for SQL Server/NT (3 GB, AWE) | String |
MEMSET | Specifies how SQL Server memory parameters have been set | String |
NTPRODLEVEL | Server edition | String |
NTVER | OS edition: A=Advanced Server, S=Server, D=Datacenter. | String |
NUMCPUS | Number of CPUs on the host which runs SQL Server. | Number |
PAGEREADSPLKP | Page reads per buffer lookup | Number |
PGLATCHWAITMS | Wait time per buffer page latch request | Number |
PHYSMEM | Physical available memory | Number |
PHYSREADSDB | Physical reads per database in a second | Number |
PHYSREADSSRV | Physical reads for whole server in a second | Number |
PHYSWRITESDB | Physical writes per database in a second | Number |
PHYSWRITESSRV | Physical writes for whole server in a second | Number |
PROBESCANS | Number of probe scans per second | Number |
PRODLEVEL | Date the executable sqlservr.exe was created. | String |
RANGESCANS | Number of range scans per second | Number |
READ_READAHEAD | Page reads per read ahead | Number |
SAPRL | SAP Release for SQL Server Monitor | Number |
SQLBATCHES | Number of SQL Batches (per second) | Number |
SQLCPUS | Maximum number of CPUs SQL Server is configured to use. | Number |
SQLEE | SQL Server edition: 'X' = Enterprise Ed., 'C' Cluster in use | String |
SQLVERSION | SQL Server Version | String |
TOTALCONNECTS | Number of total connections to SQL Server | Number |
TOTDBSZ | Database size in MB | Number |
TOTLOGSZ | Log size in MB | Number |
TRACEFLAGS | Trace flags which are currently set for SQL Server. | Number |
TRANSACTIONS | Transactions per second | Number |
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. | + | - |
WINVER | Operating system version running on SQL Server host. | String |