...
Current Activity
The information from the Overview Current Activity 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