The package STUS (SQL Server Monitor) is a standard package in SAP ERP. It belongs to the parent package BASIS.
| Package | STUS |
| Short Text | SQL Server Monitor |
| Parent Package | BASIS |
SAP Package STUS contains 7 function groups.
| SFMSS_MSTSUMLST | MSS: Statement summary list |
|---|---|
| SMSJ | MSQ functions DB access |
| STUL | MS SQL Server Functions |
| STUQ | MS SQL Server: specific functions |
| STUS | MS SQL Server specific funcitons |
| STUS_MULTICONN | Monitor group for new multi-connect |
| STXPL | MSS: SQL Explain |
SAP Package STUS contains 2 transactions.
| DB02_MSS | Remote maintainance MSS (RFC,DBCON) |
|---|---|
| ST04_MSS | Monitoring SQL Server (remote/local) |
SAP Package STUS contains 5 database tables.
| DBSTATTMSS | Table sizes |
|---|---|
| MSQSNAP | MS SQL Server: Database performance snapshot |
| MSSCNTDEAD | Cumulated deadlock statistics data |
| MSSDBSTATT | Table statistics for MS SQL Server |
| MSSDEADLCK | Database Deadlock Information for MSSQL Server |
SAP Package STUS contains 1 views.
| MSSDBSTATT_V | View on MSSDBSTATT to select fields for MONI history |
|---|
SAP Package STUS contains 122 structures.
| MSD_DBDATA | Contains information on a database |
|---|---|
| MSD_DYSERV | contains performance measures since sqlserver's last start |
| MSD_FILES | Data about operating system files which make up a db |
| MSD_PACCES | Contains data from sysperfinfo on accesses physical&logical |
| MSD_PFCACH | Contains data from the performance object cache manager |
| MSD_PMEM | Contains data from sysperfinfo on memory |
| MSD_STSERV | data about sqlserver and the host its running on |
| MSDAUTOSTA | SQL Server Index property autostats |
| MSDBACKMED | MS SQL SERVER BACKUP MEDIASETS |
| MSDBAKFILE | Sqlserver Backup file information |
| MSDCCMSJOB | MS SQL server list of CCMS planned tasks |
| MSDCHKDB | SQL Server download DBCC CHECKDB results |
| MSDDBCCOUT | SQL Server download DBCC output |
| MSDDBCCRES | MS SQL server dbcc output result set |
| MSDDBDETAS | MS SQL server database space statistics |
| MSDDBOPTS | MS SQL server database options |
| MSDDBSTATS | SQL Server DBSTATS download structure |
| MSDDEADLCK | MS SQL Server: Database deadlock information |
| MSDDWDLLS | DLL version information |
| MSDERROUT | Structure to hold SQLServer errorlog output |
| MSDEXTDIST | SQL Server table extent distribution in files |
| MSDINDSTAT | SQL Server statement download index info |
| MSDLIST | SQL Server download list |
| MSDMSSTATS | MS SQL Server MSSTATS ($MSST) |
| MSDMSSTEXD | MS SQL Server: MSSTATS with Statement Type and Object Name |
| MSDMSSTLIS | MS SQL Server MSSTATS ($MSST) |
| MSDMSSTSTA | MS SQL Server $MSST Status Record |
| MSDMSSTSUM | SQL Server stored procedure statistics summary |
| MSDMSTDOWN | SQL Server MSSTATS statement info |
| MSDNETLIBD | SQL Server download network libararies |
| MSDPRGINF | SQL Server statement download program info |
| MSDRESHIST | MS SQL Server: Database restoration history overview |
| MSDSAPSULK | MS SQL server - list of locks from sap_summary_locks |
| MSDSERVINF | SQL Server host information |
| MSDSNAPREC | SQL Server download performance history record |
| MSDSPINFO | SQL Server download stored procedure information |
| MSDSQLPERF | SQL Server DBCC SQLPERF Result |
| MSDSTATEM | SQL Server global data for SQL Statement Analysis |
| MSDSTRING | SQL Server statement download statement string |
| MSDTABLE | SQL Server download table |
| MSDTABLIST | SQL Server statement download tables per statement |
| MSDTBSTATS | SQL Server statement download table info |
| MSDTDETAIL | MS SQL Server: MSSTATS detail list |
| MSDVLINF | SQL Server download virtual log file info |
| MSDVTLFLS | SQL Server file IO statistics |
| MSDXMLST | SQL Server download XML string |
| MSQ10RANGE | MS SQL Server range with CHAR 10 |
| MSQC1RANGE | MS SQL Server range with CHAR 1 |
| MSQC4RANGE | MS SQL Server range with CHAR 4 for DBSTATTMSQ |
| MSQC5RANGE | MS SQL Server range with CHAR 5 |
| MSQLOGLIST | MS SQL Server database log list |
| MSQMSSTSUM | MS SQL Server: Stored Procedure Statistics Summary |
| MSQMSTATS | MS SQL Server MSSTATS Status |
| MSQPFINFO | MS SQL Server Profiler on: trace info directory |
| MSQPFLIST | MS SQL Server Profiler list |
| MSQPFON | MS SQL Server Profiler on: trace info |
| MSQPFOPS | MS SQL Server profiler operator |
| MSQPFPLAN | MS SQL Server Profiler: explain plan |
| MSQPFTRCID | MS SQL Server profiler trace ID list |
| MSQRANGE14 | MS SQL Server range with CHAR 14 |
| MSQWAITS | MS SQL Server DBCC Wait Statistics |
| MSS_FILES | MS SQL Server: Database File List for DB02 |
| MSS65BACK | MS SQL Server: Backup history overview |
| MSSBACKHIS | MS SQL Server: Backup history information |
| MSSBDEVLST | MS SQL Server: Backup device name list |
| MSSBUFSTT | MS SQL Server MSSDBSTATT column BUFFSTATUS |
| MSSCHGPAHI | MS SQL Server: PAHI parameter changes |
| MSSCNTDDLT | Cumulated deadlock statistics data for display only |
| MSSCONFIGU | Structure for sp_configure |
| MSSD15RANGE | MS SQL Server range with DEC 15 |
| MSSDBCOLL | MS SQL Server DB collector display structure |
| MSSDBFILES | MS SQL Server: Database space history files |
| MSSDBHIST | MS SQL Server: Database space history |
| MSSDBLIST | MS SQL Server: List of database names |
| MSSDBLOGSZ | MS SQL Server: Database log size |
| MSSDBOPTS | MS SQL Server: Database options |
| MSSDBPROP | Contains property settings of a SQL Server DB for display |
| MSSDBSIZE | MS SQL Server: Database size |
| MSSDBSZINF | MS SQL Server: Database Size Information |
| MSSDLTAB | Table Control: Download Table Contents |
| MSSDYNSUM | MS SQL Server table statistics history delta changes |
| MSSHELP | Structure for Data Elements Holding F1 Help Documentation |
| MSSI4RANGE | MS SQL Server range with INT 4 |
| MSSLOCK7 | MS SQL Server lock monitor |
| MSSLOCKINF | MS SQL-Server: Lock Information |
| MSSMSSTSUM | MS SQL Server: Stored Procedure Statistics Summary |
| MSSMSTATSUM | SQL Server: Stored Procedure Statistics Summary in DEC |
| MSSPERFMEM | Display MSQSNAP table: Memory |
| MSSPFALSTS | Display MSQSNAP table: Allocation statistics |
| MSSPFCNSTS | Display MSQSNAP table: Connection statistics |
| MSSPFDBALL | Display MSQSNAP table: Database space allocation |
| MSSPFDKSTS | Display MSQSNAP table: Disk statistics |
| MSSPFLIST | MS SQL Server Profiler list: ALV display |
| MSSPFMEUSG | Display MSQSNAP table: Internal memory usage |
| MSSPFNTSTS | Display MSQSNAP table: Network statistics |
| MSSPFSTATS | Display MSQSNAP table: Statistics |
| MSSPRCINF7 | MS SQL Server: Process Monitor |
| MSSPROCINF | MS SQL-Server: Process Information |
| MSSRANGES | MS SQL Server ranges for deadlock monitor |
| MSSRESHIST | MS SQL Server: Database restoration history overview |
| MSSSCHEMASTATS | MS SQL Server: info on table size for all schemas |
| MSSSERVER | MS SQL Server: Information |
| MSSSLOCKS | MS SQL Server: Single Deadlock Count |
| MSSSNAPHIS | MS SQL Server MSQSNAP table history list |
| MSSSPNAMES | List of stored procedure names for which to create a summary |
| MSSSPWHO | MS SQL Server: Online user status |
| MSSST04COUNTERS | Collection of key performance counters displayed in ST04 |
| MSSST04LST | MS SQL Server: ST04 Main Screen Display Structure |
| MSSSTATS1X | MS SQL Server: MSSTATS with Statement Type and Intance |
| MSSSTATS1XX | SQL Server: MSSTATAS with Statement Type& Instance in DEC |
| MSSSUBPARA | MS SQL Server: Table of Substituted Profile Parameters |
| MSSSUMDEAD | MS SQL Server: Deadlock Summary Statistics (Numbers Only) |
| MSSSYCHST | The data from syscacheobjects for display fewer columns |
| MSSTABGRWN | MS SQL Server Table Grownth |
| MSSTABHDER | Table control download: table header |
| MSSTASK | MS SQL Server task description (as from msdb..systasks) |
| MSSTASKHIS | MS SQL Server task history (parts from msdb..syshistory) |
| MSSTATSREC | MS SQL Server $MSST status record |
| MSSTBSHIST | MS SQL Server Table Statistics History |
| MSSTDETAIL | MS SQL Server MSSTATS: Detail List |
| MSSVTLFLS | MS SQL Server vitual file statistics display |
| SALMSSAL | MS SQL Server Database Alert Threshold |
SAP Package STUS contains 37 programs.
| RSMSQ000 | SQL Server Performance Analysis |
|---|---|
| RSMSQDSH | MS SQL Server Deadlock monitor |
| RSMSQPAH | MS SQL Server Parameter Changes |
| RSMSQSNP | Get database snapshot and store it in MSQSNP (called via RSCOLL00) |
| RSMSQT0D | Get statistical database snapshot data and store it into MONI |
| RSMSS062 | MS SQL Server Database Performance: Tables and Indexes |
| RSMSS100 | MSSQL: Explain Functionality |
| RSMSSBLKLCK | MS SQL Server Blocking Lockstats in ALV |
| RSMSSCRTABSCRIPT | MS SQL Server Table definition and table statistics information |
| RSMSSDBANALYZE | MS SQL Server Database Analysis |
| RSMSSDBLOG | MS SQL Server read database logs |
| RSMSSDBPAHI | MS SQL Server database parameter history |
| RSMSSDBSPACE | Compute DB size & SQL file statistics and store them to MONI |
| RSMSSDBSTATS | MS SQL Server Table History |
| RSMSSDBSZHIST | Database Space History |
| RSMSSDBUTL | MS SQL Server database utility |
| RSMSSDCN | MS SQL Server update deadlock counter table MSSCNTDEAD from MSSDEADLCK |
| RSMSSDEPEND | MS SQL Server object dependency |
| RSMSSDLD | SQL Server statement download: write statement data into MONI |
| RSMSSEXESQL | MS SQL Server execute stored procedure |
| RSMSSFILESTATS | MS SQL Server virtual file statistics |
| RSMSSHELPTEXT | MS SQL Server sp_helptext |
| RSMSSLMN | MS SQL Server Lock Monitor (Main Program) |
| RSMSSMSSTATS | MS SQL Server MSSTATS Overview |
| RSMSSMSTLST | MS SQL Server SP Statistics List |
| RSMSSPAT | Pattern report for deadlock tracking display (used by RSMSQDSH) |
| RSMSSPERFSERVER | MS SQL Server performance server |
| RSMSSRECOMPILE | MS SQL Server object dependency |
| RSMSSSERVERINFO | MS SQL Server detail information |
| RSMSSSQLPM | MS SQL Server SQL processes monitor |
| RSMSSSQLREQUEST | MS SQL Server SQL requests |
| RSMSSTABANALYZE | MS SQL Server Table Analysis |
| RSMSSTABGROW | MS SQL Server Display Top Growning Tables |
| RSMSSTABHIST | MS SQL Server store table statistics into MONI |
| RSMSSTABLEDETAIL | MS SQL Server table analysis |
| RSMSSUPDATEDBSTATS | MS SQL Server Update Database Statistics in MSSDBSTATT |
| RSMSSWAITSTATS | MS SQL Server Display DBCC SQLPERF(waitstats) |
SAP Package STUS contains 1 message classes.
| S10 | MS SQL Server Database monitor tools messages |
|---|