SAP ABAP Message Class SMMSS_ANALYZE (MSSQL Analysis and performance Tools) is used by

• Class (1)
• Function Module (22)
• Program (3)

#	Object Type	Object Name	Object Description	Package	Structure Package	Software Component
1	Function Module	GET_PROCESSINFO_MSS	get data from sysprocesses	STUN_MSS	BASIS	SAP_BASIS
2	Function Module	GET_SQLERRORLOGS_MSQ	retrieve text of SQLServer errorlogs and the sqlagent.out	STUN_MSS	BASIS	SAP_BASIS
3	Function Module	GET_VTLFILESTATS_MSS	retrieve data from ::fn_virtualfilestats (-1,-1)	STUN_MSS	BASIS	SAP_BASIS
4	Function Module	MSS_EXEC_DBCC_CHECKTABLE	Execute DBCC CHECKTABLE for a given table	STUN_MSS	BASIS	SAP_BASIS
5	Function Module	MSS_EXEC_DBCC_SHOWSTATS	Execute DBCC SHOW_STATISTICS for a given table and index	STUN_MSS	BASIS	SAP_BASIS
6	Function Module	MSS_EXPLAIN_SQL_STMT	MS SQL server function to get statistics, showplan for SQL stmt execution.	STUN_MSS	BASIS	SAP_BASIS
7	Function Module	MSS_EXPLAIN_SQL_STMT_RS	MS SQL server function to get statistics, showplan for SQL stmt execution.	STUN_MSS	BASIS	SAP_BASIS
8	Function Module	MSS_EXPLAIN_SQL_STMT_XML	MS SQL server function to get statistics, showplan for SQL stmt execution.	STUN_MSS	BASIS	SAP_BASIS
9	Function Module	MSS_GET_ALL_APPSERVER_INFO	Get Application Server info for MSS	STUN_MSS	BASIS	SAP_BASIS
10	Function Module	MSS_GET_APPSERVER_INFO	Get Application Server info for MSS	STUN_MSS	BASIS	SAP_BASIS
11	Function Module	MSS_GET_SPID_ACTIVITY	Get name of stored procedure being executed on a spid.	STUN_MSS	BASIS	SAP_BASIS
12	Function Module	MSS_GET_SQLTEXT_BY_HANDLE	MS SQL server function to get sqltext from sys.dm_exec_sql_text	STUN_MSS	BASIS	SAP_BASIS
13	Function Module	MSS_GET_SQLTEXT_BY_HISTID	MS SQL server function to get sqltext from sap_workload_history	STUN_MSS	BASIS	SAP_BASIS
14	Function Module	MSS_GET_TABLE_SIZE_INFO	Get size information on a table	STUN_MSS	BASIS	SAP_BASIS
15	Function Module	MSS_MON_OBJECT_TYPE	Find the type of an object	STUN_MSS	BASIS	SAP_BASIS
16	Function Module	MSS_MON_SET_ONLINE_INDXCREATE	Set online index creation on/off	STUN_MSS	BASIS	SAP_BASIS
17	Function Module	MSS_MON_SQLTEXT	Get SQL Text for an MSS object	STUN_MSS	BASIS	SAP_BASIS
18	Function Module	MSS_PARAMSTRING_FROM_SQLTEXT	MS SQL server function to get parameter string from sqltext	STUN_MSS	BASIS	SAP_BASIS
19	Function Module	MSS_SHOW_ABAP_CODE	MS SQL Server show ABAP code	STUN_MSS	BASIS	SAP_BASIS
20	Function Module	MSS_START_JOB	Start a SQL Agent Job	SMSS_SQLJOBS	BASIS	SAP_BASIS
21	Function Module	MSS_WMI_IN_BROWSER	Show WMI data in external browser	STUN_MSS	BASIS	SAP_BASIS
22	Function Module	MSS_XML_PLAN	MS SQL server function to get statistics, showplan for SQL stmt execution.	STUN_MSS	BASIS	SAP_BASIS