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".
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 |
---|---|---|---|---|---|---|
TABLENAME | Table name | X | MSSTABLE | CHAR | 128 | |
TOTALROWS | Number of rows | MSSNUMROWS | DEC | 8 | ||
DATASIZE | Data size in KB | MSSDATASIZE | DEC | 8 | ||
RESERVED | Reserved size in KB | MSSRESSIZE | DEC | 8 | ||
INDEXSIZE | Index size in KB | MSSINDEXSIZE | DEC | 8 | ||
ROWMODCTR | Row modification counter | MSSROWMODCTR | INT4 | 4 | ||
STATSSCHVER | Statistics schema version | MSSSTATSSCHVER | INT4 | 4 | ||
INDEXDEPTH | Depth | MSSINDDEPTH | INT4 | 4 | ||
NUMINDEXES | Number of indexes of a table | MSSNUMINDS | INT4 | 4 | ||
NUMSTATS | Number of statistics of a table | MSSNUMSTATS | INT4 | 4 | ||
STATSDATE | Last update statistics | MSSSTATSDATE | CHAR | 20 | ||
TABLEOPTIONS | Table options on locking and memory | MSSTABOPTS | CHAR | 10 | ||
BUFFSTATUS | SAP table buffering status on application server. | MSSTABBUFF | CHAR | 4 | ||
FILEGROUP | Filegroup name | MSSFG | CHAR | 128 | ||
SCANDENSITY | Scan density | MSSSCANDENSITY | DEC | 3 | ||
LOGICALFRAG | Logical scan fragmentation | MSSLOGSCANFRAG | DEC | 3 | ||
NUMPAGES | Number of pages in index level | MSSILPAGES | DEC | 9 | ||
BESTCOUNT | Ideal number of extent changes | MSSBESTCOUNT | DEC | 9 | ||
ACTUALCOUNT | Actual number of extent changes | MSSACTCOUNT | DEC | 9 | ||
EXTENTSWITCHES | Number of extent switches | MSSEXTSWITCHES | DEC | 9 | ||
LASTTABLE | CHAR | 1 | ||||
LASTRUN | CHAR | 8 | ||||
LASTDURATION | Execution duration of an operation in seconds. | MSSDURATE | INT4 | 4 |