Menu

SAP Package SMSS_ANALYZE

Database analysis tools for MS SQL Server

Technical Information

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

Package Contents

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

Function Groups

The package SMSS_ANALYZE contains 2 function groups.

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

Structures

The 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

Programs

The 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

Message Classes

The package SMSS_ANALYZE contains 1 message classes.

SMMSS_ANALYZE MSSQL Analyse und Trace Tools