MSSPPACK - MSSQL : list of DB performance snapshots
MSSQL : list of DB performance snapshots information is stored in SAP table MSSPPACK.
It is part of development package SMSS_TOOLS in software component BC-DB-MSS. This development package consists of objects that can be grouped under "Utilities for MS SQL Server".
It is part of development package SMSS_TOOLS in software component BC-DB-MSS. This development package consists of objects that can be grouped under "Utilities for MS SQL Server".
Fields for table MSSPPACK
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 3 | * |
| PACK_ID | UUID in character form | X | SYSUUID_C | CHAR | 32 | |
| CONTENT_KEY | Content key (CL_MSS_PSNAP=>GET_CONTENT_CLASSES) | CHAR | 8 | |||
| INSTSTAMP | Package data storage timestamp (YYYYMMDDhhmmss) | DEC | 8 | |||
| BNAME | User who created the snapshot | CHAR | 64 | |||
| SNAPTSTAMP | Performance package creation timestamp (YYYYMMDDhhmmss) | DEC | 8 | |||
| RESETSTAMP | Performance data "reset" timestamp (YYYYMMDDhhmmss) | DEC | 8 | |||
| LSID | Landscape management ID of database instance | CHAR | 16 | |||
| SYSID | Name of SAP System | SYSYSID | CHAR | 8 | ||
| RFCDEST | Logical destination (specified in function call) | RFCDEST | CHAR | 32 | * | |
| CON_NAME | Logical name of a database connection | DBCON_NAME | CHAR | 30 | * | |
| HOSTNAME | MSSQL Multiconnect : SQL Server name | MSSINSTANC | CHAR | 128 | ||
| DBNAME | Database name | MSSDB | CHAR | 128 | ||
| DBSCHEMA | MSSQL Multiconnect : Object source schema | MSSOBJSRC | CHAR | 128 | ||
| FLAGS | Flag array (offsets defined in CL_MSS_PSNAP=>FLAGOFF*) | CHAR | 32 | |||
| FSVERS_MAIN | File schema version - main version identifier | INT4 | 4 | |||
| FSVERS_SUB | File schema version - sub version identifier | INT4 | 4 | |||
| STATUS | Package status flags (offsets CL_MSS_PSNAP=>STATOFF*) | CHAR | 32 | |||
| STEXT | Short text | CHAR | 128 |