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.

Overview

The information from the Overview tab will match the data extracted and sent to Splunk.

Current Activity

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

Failover 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