Menu

SAP Package STUS

SQL Server Monitor

Technical Information

Package STUS
Short Text SQL Server Monitor
Parent Package BASIS

Package Contents

The package STUS is a normal package. It contains the following embedded packages and dictionary objects.

Function Groups

The 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

The package STUS contains 2 transactions.

DB02_MSS Remote maintainance MSS (RFC,DBCON)
ST04_MSS Monitoring SQL Server (remote/local)

Database Tables

The 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

The package STUS contains 1 views.

MSSDBSTATT_V View on MSSDBSTATT to select fields for MONI history

Structures

The 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

The 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

The package STUS contains 1 message classes.

S10 MS SQL Server Database monitor tools messages