MSSDBSTATT - Table statistics for MS SQL Server

Table statistics for MS SQL Server information is stored in SAP table MSSDBSTATT.
It is part of development package STUS in software component BC-DB-MSS-CCM. This development package consists of objects that can be grouped under "SQL Server Monitor".

Fields for table MSSDBSTATT

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
TABLENAMETable nameXMSSTABLECHAR128
TOTALROWSNumber of rowsMSSNUMROWSDEC8
DATASIZEData size in KBMSSDATASIZEDEC8
RESERVEDReserved size in KBMSSRESSIZEDEC8
INDEXSIZEIndex size in KBMSSINDEXSIZEDEC8
ROWMODCTRRow modification counterMSSROWMODCTRINT44
STATSSCHVERStatistics schema versionMSSSTATSSCHVERINT44
INDEXDEPTHDepthMSSINDDEPTHINT44
NUMINDEXESNumber of indexes of a tableMSSNUMINDSINT44
NUMSTATSNumber of statistics of a tableMSSNUMSTATSINT44
STATSDATELast update statisticsMSSSTATSDATECHAR20
TABLEOPTIONSTable options on locking and memoryMSSTABOPTSCHAR10
BUFFSTATUSSAP table buffering status on application server.MSSTABBUFFCHAR4
FILEGROUPFilegroup nameMSSFGCHAR128
SCANDENSITYScan densityMSSSCANDENSITYDEC3
LOGICALFRAGLogical scan fragmentationMSSLOGSCANFRAGDEC3
NUMPAGESNumber of pages in index levelMSSILPAGESDEC9
BESTCOUNTIdeal number of extent changesMSSBESTCOUNTDEC9
ACTUALCOUNTActual number of extent changesMSSACTCOUNTDEC9
EXTENTSWITCHESNumber of extent switchesMSSEXTSWITCHESDEC9
LASTTABLECHAR1
LASTRUNCHAR8
LASTDURATIONExecution duration of an operation in seconds.MSSDURATEINT44
Privacy Policy