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 |