MSSCOLLCOUNTERS SAP (Collection of key performance counters displayed in ST04) Structure details

Dictionary Type: Structure
Description: Collection of key performance counters displayed in ST04




ABAP Code to SELECT data from MSSCOLLCOUNTERS
Related tables to MSSCOLLCOUNTERS
Access table MSSCOLLCOUNTERS




Structure field list including key, data, relationships and ABAP select examples

MSSCOLLCOUNTERS 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_MSSCOLLCOUNTERS TYPE MSSCOLLCOUNTERS.

The MSSCOLLCOUNTERS 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 IOSTALLREADSRV (IOStall per read request), IOSTALLWRITESRV (IOStall per read request), IOSTALLREADDB (IOStall per read request), IOSTALLWRITEDB (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 MSSCOLLCOUNTERS 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
PGWRITEWAITMSWait time per page write request MSSPGWRITEWAITDEC16(3) MSSCOLLSLOPE
IOSTALLREADSRVIOStall per read request MSSIOSTALLREADDEC16(3) MSSCOLLSLOPE
IOSTALLWRITESRVIOStall per read request MSSIOSTALLWRITEDEC16(3) MSSCOLLSLOPE
IOSTALLREADDBIOStall per read request MSSIOSTALLREADDEC16(3) MSSCOLLSLOPE
IOSTALLWRITEDBIOStall per read request MSSIOSTALLWRITEDEC16(3) MSSCOLLSLOPE
LOGWRITEWAITMSWait time per log write request MSSLOGWRITEWAITDEC16(3) MSSCOLLSLOPE
LOGFLUSHWAITMSWait time per log flush MSSLOGFLUSHWAITDEC16(3) MSSCOLLSLOPE
LOGFLUSHSLog flushes per sec MSSLOGFLUSHSDEC16(3) MSSCOLLSLOPE
LOGFLUSHSDBLog flushes per sec MSSLOGFLUSHSDEC16(3) MSSCOLLSLOPE
LOGFLUSHSSRVLog flushes per sec MSSLOGFLUSHSDEC16(3) MSSCOLLSLOPE
PHYSREADSDBPhysical reads per database in a second MSSPHYSREADSDBDEC16(3) MSSCOLLSLOPE
PHYSWRITESDBPhysical writes per database in a second MSSPHYSWRITESDBDEC16(3) MSSCOLLSLOPE
PHYSREADSSRVPhysical reads for whole server in a second MSSPHYSREADSSRVDEC16(3) MSSCOLLSLOPE
PHYSWRITESSRVPhysical writes for whole server in a second MSSPHYSWRITESSRVDEC16(3) MSSCOLLSLOPE
BUFPGWAITMSWait time per buffer page latch request MSSPGLATCHWAITDEC16(3) MSSCOLLSLOPE
BUFPGLOOKUPSNumber of buffer page lookups per batch MSSBUFPGLOOKUPSDEC16(3) MSSCOLLSLOPE
BUFPGREADSReads triggered by buffer management MSSBUFPGREADSDEC16(3) MSSCOLLSLOPE
BUFPGWRITESwrites per second triggered by buffer management MSSBUFPGWRITESDEC16(3) MSSCOLLSLOPE
PAGEREADSPLKPPage reads per buffer lookup MSSPAGEREADSPLKDEC16(3) MSSCOLLSLOPE
READAHEADSPage reads per read ahead MSSREADAHEADDEC16(3) MSSCOLLSLOPE
READ_READAHEADSPage reads per read ahead MSSREADAHEADDEC16(3) MSSCOLLSLOPE
CPUBUSYSQL Server CPU busy counter MSSCPUBUSYDEC16(3) MSSCOLLSLOPE
CPUIDLESQL Server CPU idle counter MSSCPUIDLEDEC16(3) MSSCOLLSLOPE
IOBUSYSQL Server IO busy counter MSSIOBUSYDEC16(3) MSSCOLLSLOPE
CPUINFOCPU information (number of CPUs used) MSSCPUINFOCHAR15
LAZYWRITESLazy writes (per second) MSSLAZYWRITESDEC16(3) MSSCOLLSLOPE
BUFHITRATIODatacache hit ratio MSSBUFHITRATIODEC16(3) MSSCOLLSLOPE
CACHEHITRATIOProcedure cache hit ratio MSSCACHEHITRATIODEC16(3) MSSCOLLSLOPE
LOCKWAITMSAverage lock wait time per request MSSLOCKWAITMSDEC16(3) MSSCOLLSLOPE
LOCKESCALAverage lock escalations per second MSSLOCKESCDEC16(3) MSSCOLLSLOPE
LOCKREQNumber of lock requests per second MSSLOCKREQDEC16(3) MSSCOLLSLOPE
LATCHWAITMSAverage latch wait per request (ms) MSSLATCHWAITMSDEC16(3) MSSCOLLSLOPE
FULLSCANSNumber of full scans per second MSSFULLSCANSDEC16(3) MSSCOLLSLOPE
CHECKPOINTWAITSCheck point waits MSSCHKPTWAITSDEC16(3) MSSCOLLSLOPE
CHECKPOINTPGSCheck point pages written MSSCHKPTPAGESDEC16(3) MSSCOLLSLOPE
TOTALMEMCurrently used SQL Server memory MSSCURRMEMDEC16(1) MSSCOLLMEMSIZE
SQLCACHEMEMSQL Server SQL cache memory MSSSQLCACHEMEMDEC16(1) MSSCOLLMEMSIZE
CURRMEMCurrently used SQL Server memory MSSCURRMEMDEC16(1) MSSCOLLMEMSIZE
LOCKMEMSQL Server Memory currently used for locking MSSLOCKMEMDEC16(1) MSSCOLLMEMSIZE
CONNMEMConnection Memory sor all SQL Server connections MSSCONNMEMDEC16(1) MSSCOLLMEMSIZE
OPTMEMMemory for SQL Server Optimizer MSSOPTMEMDEC16(1) MSSCOLLMEMSIZE
TARGETMEMMax memory limit for SQL Server MSSMAXMEMDEC16(1) MSSCOLLMEMSIZE
DATABASEPGSDatacache size in MB MSSDATABASEPGSDEC16(1) MSSCOLLMEMSIZE
FREEPAGESFree pages in MB MSSFREEPGSZDEC16(1) MSSCOLLMEMSIZE
PROCCACHEPGSSize of the SQL Server procedure cache MSSPROCCACHESZDEC16(1) MSSCOLLMEMSIZE
CACHEPGSSize of whole SQL Server procedure cache MSSCACHESZDEC16(1) MSSCOLLMEMSIZE
TOTALBUFPGSTotal number of pages (buffer manager) MSSTOTALBUFPGSDEC16(1) MSSCOLLMEMSIZE
CACHEOBJCNTNatural Number INT4INT410INT4
TRANSACTIONSTransactions per second MSSTRANSACTIONSDEC16(3) MSSCOLLSLOPE
ACTTRANSACTIONSTransactions per second MSSTRANSACTIONSDEC16(3) MSSCOLLSLOPE

Key field Non-key field



How do I retrieve data from SAP structure MSSCOLLCOUNTERS using ABAP code?

As MSSCOLLCOUNTERS 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 MSSCOLLCOUNTERS as there is no data to select.

How to access SAP table MSSCOLLCOUNTERS

Within an ECC or HANA version of SAP you can also view further information about MSSCOLLCOUNTERS and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!