DBSTATTMSS - Table sizes
Table sizes information is stored in SAP table DBSTATTMSS.
It is part of development package STUN_MSS in software component BC-DB-MSS. This development package consists of objects that can be grouped under "Package for new SQL Server monitoring objects".
It is part of development package STUN_MSS in software component BC-DB-MSS. This development package consists of objects that can be grouped under "Package for new SQL Server monitoring objects".
Fields for table DBSTATTMSS
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| TABID | MS SQL Server table object id | X | MSSTABID | INT4 | 4 | |
| TABNAME | MS SQL Server object name | MSSOBJNAME | CHAR | 30 | ||
| LUPDSTAT | Analysis date (yyyymmddhhmm) | AM_DATE | CHAR | 12 | ||
| UPDDURATE | Execution duration of an operation in seconds. | MSSDURATE | INT4 | 4 | ||
| LCHCKTABLE | Analysis date (yyyymmddhhmm) | AM_DATE | CHAR | 12 | ||
| CHCKDURATE | Execution duration of an operation in seconds. | MSSDURATE | INT4 | 4 | ||
| CHECKTYPE | MS SQL Server type of check action | MSSCHKTYPE | CHAR | 1 | ||
| NROWS | Number of rows in a table | OROWS | DEC | 8 | ||
| DPAGES | MS SQL Server number of data pages in table | MSSDPAGES | INT4 | 4 | ||
| RESERVED | MS SQL Server reserved pages for table | MSSTBRESVD | INT4 | 4 | ||
| USED | MS SQL Server number of used pages of a table | MSSTBUSED | INT4 | 4 | ||
| TOTIDXPG | MS SQL Server number of index pages for all idx of one table | MSSTOTIDXP | INT4 | 4 | ||
| RESIMTXTPG | MS SQL Server number of reserved image + text pages of table | MSSRESIMTX | INT4 | 4 | ||
| USDIMTXTPG | MS SQL Server number of used image or text pages for table | MSSUSDIMTX | INT4 | 4 |