Table list used by SAP ABAP Function Module /SDF/MSS_PERFHIST (SQL Server performance history)
SAP ABAP Function Module
/SDF/MSS_PERFHIST (SQL Server performance history) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | /SDF/MSSDBDATA | SQL Server: Database options (copy of MSD_DBDATA) | ||
| 2 | /SDF/MSSDBDATA610 | SQL Server: Database options (copy of MSQ_DBDATA in 6.10) | ||
| 3 | /SDF/MSSDBDATA610 | SQL Server: Database options (copy of MSQ_DBDATA in 6.10) | SOURCE DBDATAGENERAL STRUCTURE /SDF/MSSDBDATA610 OPTIONAL |
|
| 4 | /SDF/MSSDBSIZEINFO | SQL Server: Database size information (MSSDBSIZEINFO) | ||
| 5 | /SDF/MSSDBSIZEINFO | SQL Server: Database size information (MSSDBSIZEINFO) | SOURCE DBSIZEINFO STRUCTURE /SDF/MSSDBSIZEINFO OPTIONAL |
|
| 6 | /SDF/MSSDBSIZEINFODBACP | SQL Server: Database size information (MSSDBSIZEINFO) DBACP | ||
| 7 | /SDF/MSSDYSERV | SQL Server: Dynamic server data set (copy of MSD_DYSERV) | ||
| 8 | /SDF/MSSDYSERV | SQL Server: Dynamic server data set (copy of MSD_DYSERV) | SOURCE DYNAMICSERVER STRUCTURE /SDF/MSSDYSERV OPTIONAL |
|
| 9 | /SDF/MSSPACCES | SQL Server: Access methods data set (copy of MSD_PACCES) | ||
| 10 | /SDF/MSSPACCES610 | SQL Server: Access methods data set (copy of MSS_PACCES 610) | ||
| 11 | /SDF/MSSPACCES610 | SQL Server: Access methods data set (copy of MSS_PACCES 610) | SOURCE ACCESSMTHS STRUCTURE /SDF/MSSPACCES610 OPTIONAL |
|
| 12 | /SDF/MSSPFCACH | SQL Server: Cache usage data set (copy of MSD_PFCACH) | ||
| 13 | /SDF/MSSPFCACH | SQL Server: Cache usage data set (copy of MSD_PFCACH) | SOURCE CACHEINFO STRUCTURE /SDF/MSSPFCACH OPTIONAL |
|
| 14 | /SDF/MSSPFCACH640 | SQL Server: Cache usage data set (copy of MSS_PFCACH) | ||
| 15 | /SDF/MSSPFCACHDBACP | SQL Server: Cache usage data set (copy of MSS_PFCACH) | ||
| 16 | /SDF/MSSPMEM | SQL Server: Memory usage data set (copy of MSD_PMEM) | SOURCE MEMUSAGE STRUCTURE /SDF/MSSPMEM OPTIONAL |
|
| 17 | /SDF/MSSPMEM | SQL Server: Memory usage data set (copy of MSD_PMEM) | ||
| 18 | /SDF/MSSPMEM640 | SQL Server: Memory usage data set (copy of MSS_PMEM) | ||
| 19 | /SDF/MSSSNAPREC | SQL Server: History time stamp (copy of MSDSNAPREC) | ||
| 20 | /SDF/MSSSNAPREC | SQL Server: History time stamp (copy of MSDSNAPREC) | SOURCE PERFHISTREC STRUCTURE /SDF/MSSSNAPREC OPTIONAL |
|
| 21 | /SDF/MSSSTSERV | SQL Server: Static server data set (copy of MSD_STSERV) | ||
| 22 | /SDF/MSSSTSERV620 | SQL Server: Static server data set (copy of MSS_STSERV 620) | ||
| 23 | /SDF/MSSSTSERV_ALL | SQL Server: Static server data set (copy of MSS_STSERV 620) | ||
| 24 | /SDF/MSSSTSERV_ALL | SQL Server: Static server data set (copy of MSS_STSERV 620) | SOURCE STATICSERVER STRUCTURE /SDF/MSSSTSERV_ALL OPTIONAL |
|
| 25 | /SDF/MSSTOTTABSIZEINFO | SQL Server: Information on the total size of all tables | ||
| 26 | /SDF/MSSTOTTABSIZEINFO | SQL Server: Information on the total size of all tables | SOURCE TOTTABSIZEINFO STRUCTURE /SDF/MSSTOTTABSIZEINFO OPTIONAL |
|
| 27 | /SDF/TABLE | Table with 30 free text columns | SOURCE VARIOUS STRUCTURE /SDF/TABLE OPTIONAL |
|
| 28 | /SDF/TABLE | Table with 30 free text columns | SOURCE VALUE(AREA) LIKE /SDF/TABLE-FIELD1 DEFAULT 'MACYZT' |
|
| 29 | /SDF/TABLE | Table with 30 free text columns | SOURCE VALUE(DAYS) LIKE /SDF/TABLE-FIELD1 DEFAULT '7' |
|
| 30 | DD02V | Generated Table for View | ||
| 31 | DD03P | Structure | ||
| 32 | ENLFDIR | Additional Attributes for Function Modules | ||
| 33 | SCAL | Structure for factory calendar function modules |