SAP Package STUS
SQL Server Monitor
Unsere Literaturempfehlung
SAP-Änderungs- und Transportmanagement: Architektur und Wartung der SAP-Systemlandschaft
Das Standardwerk zum Änderungs- und Transportmanagement in der 4. Auflage! In diesem Buch finden Sie alle Informationen, die Sie zum Planen, Implementieren und Warten von Systemlandschaften benötigen. Sie lernen die Grundlagen und die Bedienung aller relevanten Werkzeuge und erhalten detaillierte Anleitungen zur Änderungs- und Transportverwaltung. Diese Neuauflage berücksichtigt Neuerungen in den Bereichen SAP NetWeaver AS Java und Development Infrastructure, CTS+, SAP Solution Manager und Enhancement Packages. Bringen Sie ihr Wissen auf den neuesten Stand!
Bei amazon.de ansehen →
The package STUS (SQL Server Monitor) is a standard package in SAP ERP. It belongs to the parent package BASIS.
Technical Information
| Package | STUS |
| Short Text | SQL Server Monitor |
| Parent Package | BASIS |
Function Groups
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 |
Transactions
SAP Package STUS contains 2 transactions.
| DB02_MSS | Remote maintainance MSS (RFC,DBCON) |
|---|---|
| ST04_MSS | Monitoring SQL Server (remote/local) |
Database Tables
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 |
Views
SAP Package STUS contains 1 views.
| MSSDBSTATT_V | View on MSSDBSTATT to select fields for MONI history |
|---|
Structures
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 |
Programs
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) |
Message Classes
SAP Package STUS contains 1 message classes.
| S10 | MS SQL Server Database monitor tools messages |
|---|