SAP Package SMSS_DBACCESS
Database system information for MS SQL Server
Unsere Literaturempfehlung
Kundeneigene Erweiterungen mit ABAP: User-Exits, klassische und neue BAdIs, Switch und Enhancement Framework
Alle Technologien in einem Band! Ob Sie zukunftssichere Erweiterungen programmieren oder mit den Modifikationen in Ihren SAP-Systemen aufräumen möchten – hier erhalten Sie das erforderliche Wissen. Jede Methode wird ausführlich und mit Codebeispielen erläutert: User-Exits, klassische und neue BAdIs, Business Transaction Events, implizite und explizite Erweiterungspunkte u. v. m.
Bei amazon.de ansehen →
The package SMSS_DBACCESS (Database system information for MS SQL Server) is a standard package in SAP ERP. It belongs to the parent package BASIS.
Technical Information
| Package | SMSS_DBACCESS |
| Short Text | Database system information for MS SQL Server |
| Parent Package | BASIS |
Function Groups
SAP Package SMSS_DBACCESS contains 6 function groups.
| SFMSS_CONFIG | DB Configuration functions for MSSQL |
|---|---|
| SFMSS_DBUTIL | Database utility functions for MSSQL |
| SFMSS_MISC | Miscellaneous system functions for MSSQL |
| SFMSS_PERF | Performance related functions for MSSQL |
| SFMSS_SIZE | Sizing information functions for MSSQL |
| SFMSS_SYSTAB | System table functions for MSSQL |
Structures
SAP Package SMSS_DBACCESS contains 94 structures.
| MSQ_DBCNFG | Contains the SQL server parameter values |
|---|---|
| MSQ_DBDATA | Contains information on a database |
| MSQ_DYSERV | contains performance measures since sqlserver's last start |
| MSQ_FILES | Data about operating system files which make up a db |
| MSQ_LSTAT | SQL Server structure to hold stats on error or agent logs |
| MSQ_PACCES | Contains data from sysperfinfo on accesses physical&logical |
| MSQ_PDBMGR | Contains data from the performance object Databases. |
| MSQ_PERSEC | Data structure to present per second changes in perf data |
| MSQ_PFCACH | Contains data from the performance object cache manager |
| MSQ_PLOCKS | Contains data from the performance object lock manager |
| MSQ_PMEM | Contains data from sysperfinfo on memory |
| MSQ_PROCES | Data on the processes connected SQL Server |
| MSQ_STSERV | data about sqlserver and the host its running on |
| MSQ_VERDAT | structure to return release date of function group smss |
| MSQBLOLCKS | MS SQL server blocked locks |
| MSQBLOPROS | MS SQL server blocked processes |
| MSQCCMSTSK | MS SQL server list of CCMS planned tasks |
| MSQCOLLIST | MS SQL server - table column and type list |
| MSQCONFIGU | MS SQL server - structure of sp_configure |
| MSQCONFPAR | MS SQL server - configuration options |
| MSQDBASES | MS SQL server databases ( as from sysdatabases ) |
| MSQDBASESZ | MS SQL server Database size details |
| MSQDBCCRES | MS SQL server dbcc output result set |
| MSQDBDETAS | MS SQL server database space statistics |
| MSQDBLIST | MS SQL server list of database names |
| MSQDBLOGSZ | MS SQL server - log file space status |
| MSQDBOPTS | MS SQL server database options |
| MSQDBUSERS | MS SQL server user information etc., |
| MSQDNSITY | Table density information |
| MSQERROUT | Structure to hold SQLServer errorlog output |
| MSQEXPLAIN | MS SQL server - sql statement execution plan options |
| MSQEXPORT | MS SQL server - structure to hold export parameters |
| MSQIDXDETS | MS SQL server - Index details & statistics |
| MSQIMPORT | MS SQL server - structure to hold import parameters |
| MSQJOBHIS | MS SQL server job history ( as from msdb..sysjobhistory ) |
| MSQJOBSTEP | MS SQL server jobsteps ( as from msdb..sysjobsteps) |
| MSQLOCKINF | MS sql server lock info information for blockers and waiters |
| MSQLOGSZ | MS SQL server - log size |
| MSQOBJECTS | MS SQL server system objects ( as from sysobjects ) |
| MSQPROCACH | MS SQL server procedure cache activity |
| MSQPROCESS | MS SQL server processes ( as from sysprocesses ) |
| MSQPROCINF | MS SQL server - processes informations |
| MSQREFHLP | MS SQL Server Reference help fields |
| MSQSAPLCKS | MS SQL server sap locks (as from sap_locks) |
| MSQSAPSULK | MS SQL server - list of locks from sap_summary_locks |
| MSQSERTIME | MS SQL server - startup time |
| MSQSERVER | MS SQL server information |
| MSQSHCONTG | Displays fragmentation info for data and indexes of a table |
| MSQSPHPIDX | MS SQL server - Sp_helpindex structure results |
| MSQSPMONI | MS SQL server - SP monitor statistics values |
| MSQSPPARAM | MS SQL server stored procedure parameter structure |
| MSQSPWHO | MS SQL server on line user status |
| MSQSQLCODE | MS SQL server structure to get the sp text |
| MSQSQLRES | MS SQL server - sql command output |
| MSQSTMTINF | SMS SQL server created stored procedure information |
| MSQSTPRTXT | MS SQL server - stored procedure text |
| MSQSYCHOBJ | The data from syscacheobjects |
| MSQSYCHST | The data from syscacheobjects |
| MSQSYCONFI | MS SQL server configuration options ( as from sysconfigures) |
| MSQSYSDEV | MS SQL server dump devices (as from sysdevices) |
| MSQSYSIDX | MS SQL Server: Index Details ( As From Sysindexes ) |
| MSQSYSJOBS | MS SQL server list of jobs ( as from msdb..sysjobs) |
| MSQTABLST | List of table names. |
| MSQTABOPT | MS SQL Server - Table |
| MSQTABSTAT | MS SQL server table statistics |
| MSQTOPLARG | MS SQL server largest tables in database |
| MSQTOPMODI | MS SQL server top modified tables in db since last startup |
| MSQVTLFLS | MS SQL Server Information from ::fn_virtualfilestats |
| MSS_ANYSCHEMA | SAP schema |
| MSS_DBDATA | Contains property settings of a SQL Server database |
| MSS_PACCES | Contains data from sysperfinfo on accesses physical&logical |
| MSS_PFCACH | Contains data from the performance object cache manager |
| MSS_PLOCKS | Contains data from the performance object lock manager |
| MSS_PMEM | Contains data from sysperfinfo on memory |
| MSS_SCHEMA | SAP schema |
| MSS_STSERV | data about sqlserver and the host its running on |
| MSS_WAITSTATS | return structure from dbcc sqlperf(waitstats) |
| MSSDATABASE | Name + access permission |
| MSSDBCCOUT | DBCC command output |
| MSSDBLOCKS | structure returned about blocking db locks for SQL Server |
| MSSDBLOCKS_WP | MS SQL Server lock monitor |
| MSSDBSIZEINFO | Database size information |
| MSSDENSITY | Table density information |
| MSSINDINFOCOLL | Collection of index information |
| MSSINDMISC | Misc. index information |
| MSSINDMISCINFO | Index name + misc. index information |
| MSSSHOWCONOUT | Output of dbcc showcontig |
| MSSSYCHSTX | Syscacheobjects extended by R/3 specific columns |
| MSSTABCOLS | Native SQL Server column names and types |
| MSSTABSIZEINFO | Table size information |
| MSSTOPLARGE | Top large tables |
| MSSTOPMODI | Top modified tables |
| MSSTOTTABSIZEINFO | Information on the total size of all tables |
| MSSXPLPLAN | Structured output from queries when set showplan_all is on. |
Message Classes
SAP Package SMSS_DBACCESS contains 1 message classes.
| SMMSS_DBACCESS | Messages for dev. class SMSS_DBACCESS |
|---|