SAP Package SMSS_ANALYZE

The package SMSS_ANALYZE (Database analysis tools for MS SQL Server) is a standard package in SAP ERP. It belongs to the parent package BASIS.

Package	SMSS_ANALYZE
Short Text	Database analysis tools for MS SQL Server
Parent Package	BASIS

SAP Package SMSS_ANALYZE contains 2 function groups.

SFMSS_ANALYZE	MSS: Functions for performance analysis
SFMSS_MONSYSCAT	MSS System Catalog Monitoring functions

SAP Package SMSS_ANALYZE contains 16 structures.

MSSAPPSERVER	MSS Information about an appserver
MSSCOLLCOUNTERS	Collection of key performance counters displayed in ST04
MSSCOLLODESC_SMALL	Smaller version of MSSCOLLDESC
MSSCOLLRESI_SMALL	smaller version of MSSCOLLRESI
MSSCOLLSERIEGRID	structure for snapshot collecotr display
MSSFILELINE	Lines in a text file
MSSRAWDATA	Raw data line
MSSSTATS1	MS SQL Server MSSTATS ($MSST)
MSSTREVNT	PROF: List with Event Classes for F4 Help
MSSTRINIT	PROF: Header for trace display
MSSTRLIST	PROF : List of all SQL Profiler Traces
MSSTRSHOW	PROF : SQL Profiler Trace with a short text field
MSSTRTEXT	PROF: Long text field for the trace
MSSTRXPL	PROF : Explain Rowset
MSSXPLPROPS	Property structure to display Explain tree node properties.
MSSXPLTREEITM	Tree item for Explain tree control

SAP Package SMSS_ANALYZE contains 10 programs.

MSSTRPROF2000	MSSQL 2000 Profiler Trace
RSMSS_DBSL_PROFILE_SWITCH	Dynamic Parameters for MSSQL
RSMSS_DBSLPROF	Simple report to switch dbsl profile on/off
RSMSS_SLOWSQL	Analyze slow SQL statements
RSMSS_SLOWSQL_RF_ANALYZE	Analyze slow SQL statements
RSMSS_SLOWSQL_STATS_RESET	Reset slow SQL statistics data.
RSMSS_SLOWSQL_STATS_SWITCH	Switch slow SQL statistics collection on/off.
RSMSSCOLLANA	Display of collector data
RSMSSDWDLLS	Program RSMSSDWDLLS
RSMSSST04LIST	Report for ST04 List Output for Benchmarks

SAP Package SMSS_ANALYZE contains 1 message classes.

SMMSS_ANALYZE	MSSQL Analyse und Trace Tools

Database analysis tools for MS SQL Server