MSSST04COUNTERS SAP (Collection of key performance counters displayed in ST04) Structure details
Description: Collection of key performance counters displayed in ST04
Related tables to MSSST04COUNTERS
Access table MSSST04COUNTERS
Structure field list including key, data, relationships and ABAP select examples
MSSST04COUNTERS is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Collection of key performance counters displayed in ST04" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_MSSST04COUNTERS TYPE MSSST04COUNTERS.
The MSSST04COUNTERS table consists of various fields, each holding specific information or linking keys about Collection of key performance counters displayed in ST04 data available in SAP. These include LOGWRITEWAITMS (Wait time per log write request), LOGFLUSHWAITMS (Wait time per log flush), LOGFLUSHES (Number of log flushes), IOSTALLREAD (IOStall per read request).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP MSSST04COUNTERS structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
PGLATCHWAITMS | Wait time per buffer page latch request | MSSPGLATCHWAIT | DEC | 16(3) | MSSCOLLSLOPE | ||||
LOGWRITEWAITMS | Wait time per log write request | MSSLOGWRITEWAIT | DEC | 16(3) | MSSCOLLSLOPE | ||||
LOGFLUSHWAITMS | Wait time per log flush | MSSLOGFLUSHWAIT | DEC | 16(3) | MSSCOLLSLOPE | ||||
LOGFLUSHES | Number of log flushes | MSSLOGFLUSHES | DEC | 16(3) | MSSCOLLSLOPE | ||||
IOSTALLREAD | IOStall per read request | MSSIOSTALLREAD | DEC | 16(3) | MSSCOLLSLOPE | ||||
IOSTALLWRITE | IOStall per read request | MSSIOSTALLWRITE | DEC | 16(3) | MSSCOLLSLOPE | ||||
PHYSREADSDB | Physical reads per database in a second | MSSPHYSREADSDB | DEC | 16(3) | MSSCOLLSLOPE | ||||
PHYSWRITESDB | Physical writes per database in a second | MSSPHYSWRITESDB | DEC | 16(3) | MSSCOLLSLOPE | ||||
PHYSREADSSRV | Physical reads for whole server in a second | MSSPHYSREADSSRV | DEC | 16(3) | MSSCOLLSLOPE | ||||
PHYSWRITESSRV | Physical writes for whole server in a second | MSSPHYSWRITESSRV | DEC | 16(3) | MSSCOLLSLOPE | ||||
BUFPGWAITMS | Wait time to read a page into buffer | MSSBUFPGWAIT | DEC | 16(3) | MSSCOLLSLOPE | ||||
BUFPGLOOKUPS | Number of buffer page lookups per batch | MSSBUFPGLOOKUPS | DEC | 16(3) | MSSCOLLSLOPE | ||||
PAGEREADSPLKP | Page reads per buffer lookup | MSSPAGEREADSPLK | DEC | 16(3) | MSSCOLLSLOPE | ||||
READ_READAHEAD | Page reads per read ahead | MSSREADAHEAD | DEC | 16(3) | MSSCOLLSLOPE | ||||
SQLBATCHES | Number of SQL Batches (per second) | MSSSQLBATCHES | DEC | 16(3) | MSSCOLLSLOPE | ||||
TRANSACTIONS | Transactions per second | MSSTRANSACTIONS | DEC | 16(3) | MSSCOLLSLOPE | ||||
FULLSCANS | Number of full scans per second | MSSFULLSCANS | DEC | 16(3) | MSSCOLLSLOPE | ||||
RANGESCANS | Number of range scans per second | MSSRANGESCANS | DEC | 16(3) | MSSCOLLSLOPE | ||||
IDXSEARCHES | Number of index searches per second | MSSIDXSEARCHES | DEC | 16(3) | MSSCOLLSLOPE | ||||
PROBESCANS | Number of probe scans per second | MSSPROBESCANS | DEC | 16(3) | MSSCOLLSLOPE | ||||
CPUBUSY | SQL Server CPU busy counter | MSSCPUBUSY | DEC | 16(3) | MSSCOLLSLOPE | ||||
CPUIDLE | SQL Server CPU idle counter | MSSCPUIDLE | DEC | 16(3) | MSSCOLLSLOPE | ||||
IOBUSY | SQL Server IO busy counter | MSSIOBUSY | DEC | 16(3) | MSSCOLLSLOPE | ||||
LAZYWRITES | Lazy writes (per second) | MSSLAZYWRITES | DEC | 16(3) | MSSCOLLSLOPE | ||||
SAPRL | SAP Release for SQL Server Monitor | MSSSAPRL | CHAR | 4 | |||||
CPUINFO | CPU information (number of CPUs used) | MSSCPUINFO | CHAR | 15 | |||||
TRACEFLAGS | Trace flags which are currently set for SQL Server. | MSQSSTFLG | CHAR | 255 | CHAR255 | ||||
TOTALCONNECTS | Number of total connections to SQL Server | MSSTOTLCONS | INT4 | 10 | |||||
DBCONNECTS | Number of Connections to current database | MSSDBCONS | INT4 | 10 | |||||
PHYSMEM | Physical available memory | MSSPHYSMEM | DEC | 16(1) | MSSCOLLMEMSIZE | ||||
CURRMEM | Currently used SQL Server memory | MSSCURRMEM | DEC | 16(1) | MSSCOLLMEMSIZE | ||||
MAXMEM | Max memory limit for SQL Server | MSSMAXMEM | DEC | 16(1) | MSSCOLLMEMSIZE | ||||
LOCKMEM | SQL Server Memory currently used for locking | MSSLOCKMEM | DEC | 16(1) | MSSCOLLMEMSIZE | ||||
MEMSET | Specifies how SQL Server memory parameters have been set | MSQMEMSET | CHAR | 10 | CHAR010 | ||||
MEMOPT | Memory options for SQL Server/NT (3 GB, AWE) | MSSMEMOPT | CHAR | 20 | |||||
DATABUFFERSZ | Datacache size in MB | MSSDATABASEPGS | DEC | 16(1) | MSSCOLLMEMSIZE | ||||
CACHESZ | Size of whole SQL Server procedure cache | MSSCACHESZ | DEC | 16(1) | MSSCOLLMEMSIZE | ||||
FREEPGSZ | Free pages in MB | MSSFREEPGSZ | DEC | 16(1) | MSSCOLLMEMSIZE | ||||
BUFHITRATIO | Datacache hit ratio | MSSBUFHITRATIO | DEC | 16(3) | MSSCOLLSLOPE | ||||
CACHEHITRATIO | Procedure cache hit ratio | MSSCACHEHITRATIO | DEC | 16(3) | MSSCOLLSLOPE | ||||
WINVER | Operating system version running on SQL Server host. | MSQSSWVER | CHAR | 80 | CHAR80 | ||||
SQLVERSION | SQL Server Version | MSSSQLVER | CHAR | 100 | |||||
TOTDBSZ | Database size in MB | MSS_DBSIZE | DEC | 15 | |||||
DBFREE | Free space in database in MB | MSS_DBFREESIZE | INT4 | 10 | |||||
TOTLOGSZ | Log size in MB | MSS_LOGSIZE | DEC | 15 | |||||
LOGFREE | Free log space in MB | MSS_LOGFREESIZE | INT4 | 10 | |||||
DBSTRTDATE | Date when SQL Server was started | MSSDBSTARTDATE | DATS | 8 | SYDATS | ||||
DBSTRTTIME | Time when SQL Server was started | MSSDBSTARTTIME | TIMS | 6 | SYTIME | ||||
ANALYSISDATE | Date when analysis data was read | MSSANADATE | DATS | 8 | SYDATS | ||||
ANALYSISTIME | Time when analysis data was read | MSSANATIME | TIMS | 6 | SYTIME |
Key field | Non-key field |
How do I retrieve data from SAP structure MSSST04COUNTERS using ABAP code?
As MSSST04COUNTERS is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on MSSST04COUNTERS as there is no data to select.How to access SAP table MSSST04COUNTERS
Within an ECC or HANA version of SAP you can also view further information about MSSST04COUNTERS and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects