Menu

SAP Package SMSS_DBACCESS

Database system information for MS SQL Server

Recommended Now

Fire TV Stick Lite Essentials Bundle

This bundle contains Amazon Fire TV Stick Lite and Mission USB Power Cable. The USB power cable eliminates the need to find an AC outlet near your TV by powering Amazon Fire TV directly from your TV's USB port. Includes special power management circuitry that enhances the peak power capability of the USB port by storing excess energy and then releasing it as needed.

Check it out on amazon.com →

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