Data Element list used by SAP ABAP Table MSSST04COUNTERS (Collection of key performance counters displayed in ST04)
SAP ABAP Table 
MSSST04COUNTERS (Collection of key performance counters displayed in ST04) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 |  Data Element |
MSQMEMSET | Specifies how SQL Server memory parameters have been set | |
| 2 | Data Element |
MSQSSTFLG | Trace flags which are currently set for SQL Server. | |
| 3 | Data Element |
MSQSSWVER | Operating system version running on SQL Server host. | |
| 4 | Data Element |
MSSANADATE | Date when analysis data was read | |
| 5 | Data Element |
MSSANATIME | Time when analysis data was read | |
| 6 | Data Element |
MSSBUFHITRATIO | Datacache hit ratio | |
| 7 | Data Element |
MSSBUFPGLOOKUPS | Number of buffer page lookups per batch | |
| 8 | Data Element |
MSSBUFPGWAIT | Wait time to read a page into buffer | |
| 9 | Data Element |
MSSCACHEHITRATIO | Procedure cache hit ratio | |
| 10 | Data Element |
MSSCACHESZ | Size of whole SQL Server procedure cache | |
| 11 | Data Element |
MSSCPUBUSY | SQL Server CPU busy counter | |
| 12 | Data Element |
MSSCPUIDLE | SQL Server CPU idle counter | |
| 13 | Data Element |
MSSCPUINFO | CPU information (number of CPUs used) | |
| 14 | Data Element |
MSSCURRMEM | Currently used SQL Server memory | |
| 15 | Data Element |
MSSDATABASEPGS | Datacache size in MB | |
| 16 | Data Element |
MSSDBCONS | Number of Connections to current database | |
| 17 | Data Element |
MSSDBSTARTDATE | Date when SQL Server was started | |
| 18 | Data Element |
MSSDBSTARTTIME | Time when SQL Server was started | |
| 19 | Data Element |
MSSFREEPGSZ | Free pages in MB | |
| 20 | Data Element |
MSSFULLSCANS | Number of full scans per second | |
| 21 | Data Element |
MSSIDXSEARCHES | Number of index searches per second | |
| 22 | Data Element |
MSSIOBUSY | SQL Server IO busy counter | |
| 23 | Data Element |
MSSIOSTALLREAD | IOStall per read request | |
| 24 | Data Element |
MSSIOSTALLWRITE | IOStall per read request | |
| 25 | Data Element |
MSSLAZYWRITES | Lazy writes (per second) | |
| 26 | Data Element |
MSSLOCKMEM | SQL Server Memory currently used for locking | |
| 27 | Data Element |
MSSLOGFLUSHES | Number of log flushes | |
| 28 | Data Element |
MSSLOGFLUSHWAIT | Wait time per log flush | |
| 29 | Data Element |
MSSLOGWRITEWAIT | Wait time per log write request | |
| 30 | Data Element |
MSSMAXMEM | Max memory limit for SQL Server | |
| 31 | Data Element |
MSSMEMOPT | Memory options for SQL Server/NT (3 GB, AWE) | |
| 32 | Data Element |
MSSPAGEREADSPLK | Page reads per buffer lookup | |
| 33 | Data Element |
MSSPGLATCHWAIT | Wait time per buffer page latch request | |
| 34 | Data Element |
MSSPHYSMEM | Physical available memory | |
| 35 | Data Element |
MSSPHYSREADSDB | Physical reads per database in a second | |
| 36 | Data Element |
MSSPHYSREADSSRV | Physical reads for whole server in a second | |
| 37 | Data Element |
MSSPHYSWRITESDB | Physical writes per database in a second | |
| 38 | Data Element |
MSSPHYSWRITESSRV | Physical writes for whole server in a second | |
| 39 | Data Element |
MSSPROBESCANS | Number of probe scans per second | |
| 40 | Data Element |
MSSRANGESCANS | Number of range scans per second | |
| 41 | Data Element |
MSSREADAHEAD | Page reads per read ahead | |
| 42 | Data Element |
MSSSAPRL | SAP Release for SQL Server Monitor | |
| 43 | Data Element |
MSSSQLBATCHES | Number of SQL Batches (per second) | |
| 44 | Data Element |
MSSSQLVER | SQL Server Version | |
| 45 | Data Element |
MSSTOTLCONS | Number of total connections to SQL Server | |
| 46 | Data Element |
MSSTRANSACTIONS | Transactions per second | |
| 47 | Data Element |
MSS_DBFREESIZE | Free space in database in MB | |
| 48 | Data Element |
MSS_DBSIZE | Database size in MB | |
| 49 | Data Element |
MSS_LOGFREESIZE | Free log space in MB | |
| 50 | Data Element |
MSS_LOGSIZE | Log size in MB |
