SAP ABAP Program SAPLSMSSDATA (SAPLSMSSDATA)
Basic Data
Program SAPLSMSSDATA  
Program Type F Function group  
Attributes
Status    
Application S Basis  
Authorization Group  
Logical database D$S Processing without database  
Selection screen  
Editor lock Fixed point arithmetic  
Unicode checks active Start using variant  
Function Group
Include Function Module Short Description Mode
01   GET_SQLERRORLOGS_MSQ   retrieve text of SQLServer errorlogs and the sqlagent.out   R  
02   GET_DWDLLS_MSS   retrieve blocking/locking data   R  
03   GET_SQLSETUP_MSS   retrievesqlsetup messages from rz20 sqlscript   R  
04   MSS_QUERY_SQLERRORLOGS   query the sql error logs for an input phrase   R  
05   GET_VTLFILESTATS_MSS   retrieve data from ::fn_virtualfilestats (-1,-1)   R  
06   GET_CONFIGPARAMS_MSQ   MS SQL server function to get configuration options   R  
07   GET_DBDATA_MSS   get data on property settings of a SQL Server database   R  
08   GET_SQLFILES_MSS   get data on the files of a SQL Server database   R  
09   GET_STATICSERVER_MSS   get data on the Server and SQL Server system is on   R  
10   MSS_GET_SP_CONFIG_VALUE   Function to get the value for a configuration option   R  
11   MSS_WMI_IN_BROWSER   Show WMI data in external browser    
12   MSS_GET_SQLTEXT_BY_HISTID   MS SQL server function to get sqltext from sap_workload_history   R  
14   GET_LARGEST_TABLES_MSQ   MS SQL server function to get the largest tables in database   R  
15   GET_LOGSIZE_MSQ   MS SQL server function to get log file details   R  
16   GET_TABLE_SIZE_MSS   Calculate/retrieve size of a database table (MSSQL)    
17   GET_TOP_MODIFIED_TABLES_MSQ   MS sql server function to get the top modified tables since last startup   R  
18   MSS_GET_DBSZHIST   Get the table size history for a given table   R  
19   MSS_GET_FILESZHIST   Get the file size history   R  
20   MSS_GET_TABHIST   Get the table size history for a given table   R  
21   MSS_GET_TABHIST_DL_LIST   Get the fastest growing tables in the table history   R  
22   MSS_GET_TABHIST_LIST   Get a list of the tables in the table size history   R  
24   MSS_TABLE_DATA_READ   Get size information on a table   R  
27   GET_DYNAMICSERVER_MSQ   retrieve data about sql server available from the @@variables   R  
28   GET_PROCESSINFO_MSS   get data from sysprocesses   R  
29   GET_SQLPERFACCESS_MSS   Retrieve data from the counter objects: ACCESS, BUFFER, and SQL Statistics   R  
30   GET_SQLPERFCACHE_MSS   retrieve data from the sap_perfdb from the cache object   R  
31   GET_SQLPERFLOCKS_MSS   retrieve data from the counter objects: LOCKS   R  
32   GET_SQLPERFMEMORY_MSS   retrieve data from sap_perfdb on memory usage   R  
33   MSS_EXPLAIN_SQL_STMT   MS SQL server function to get statistics, showplan for SQL stmt execution.   R  
34   MSS_EXPLAIN_SQL_STMT_RS   MS SQL server function to get statistics, showplan for SQL stmt execution.   R  
35   MSS_EXPLAIN_SQL_STMT_XML   MS SQL server function to get statistics, showplan for SQL stmt execution.   R  
36   MSS_GET_SESCONREQ   retrieve the connections,session,request data for active requests   R  
44   MSS_PLAN_ATTRIBUTES   MS SQL server function to get statistics, showplan for SQL stmt execution.   R  
45   MSS_SHOWPLAN_XML2ABAP   MS SQL function to transform sql2005 XML showplan to an internal table    
46   MSS_XML_PLAN   MS SQL server function to get statistics, showplan for SQL stmt execution.   R  
48   MSS_FIND_SQLSTRING_START   find the start of a SQL String after the parameter list   R  
49   MSS_FORMAT_BODY   Format the body of a sql statement into an internal table    
50   MSS_FORMAT_PARAMETERS   Format the parameters of a sql statement into an internal table    
52   MSS_GET_SPID_ACTIVITY   Get name of stored procedure being executed on a spid.   R  
54   MSS_GET_VERSION   Get MS SQL Server version   R  
55   MSS_RECOMPILE   MS SQL Server function to execute sql command   R  
56   MSS_IDX_STATS_IN_BROWSER   Execute DBCC SHOW_STATISTICS for a given table and index    
57   MSS_GET_VIEW_INFO   Get information on a view   R  
58   MSS_GET_TOP_N_TABLES   Get the top n largest/modified tables   R  
59   MSS_GET_TABLE_SIZE_INFO   Get size information on a table   R  
62   MSS_GET_STATS_SCHEMA_VER   Get the statistics schema version of a table   R  
63   MSS_GET_SELECTIVITY   Get the selectivity of a table   R  
64   MSS_GET_SCHEMA_SIZE_INFO   Get information on the size of all tables and indexes in a schema   R  
65   MSS_GET_SCHEMAS   Get all SAP schemas in a database   R  
66   MSS_GET_SAP_SCHEMAS   Get all SAP schemas in a database   R  
69   MSS_GET_DENSITY   Get density information on a table   R  
70   MSS_GET_DB_SIZE_INFO   Get information on the size of a database   R  
71   MSS_GET_DB_SIZE_DETAILS   Get information on the size of all tables and indexes in a database   R  
72   MSS_GET_DATABASES   Get all databases in an instance   R  
73   MSS_EXEC_UPDATESTATS   Execute UPDATE STATISTICS for a given table (and index)   R  
74   MSS_EXEC_DBCC_UPDATEUSAGE   Execute DBCC UPDATEUSAGE for a given table (and index)   R  
75   MSS_EXEC_DBCC_SHOWSTATS   Execute DBCC SHOW_STATISTICS for a given table and index   R  
76   MSS_EXEC_DBCC_SHOWCONTIG   Execute DBCC SHOWCONTIG for a given table (and index)   R  
77   MSS_EXEC_DBCC_CHECKTABLE   Execute DBCC CHECKTABLE for a given table   R  
78   MSS_EXEC_DBCC_CHECKDB   Execute DBCC CHECKDB for a given database   R  
79   MSS_COL_STATS_IN_BROWSER   Show column statistics in external browser    
81   MSS_CHECK_SQLAGENT_STARTED   Function to check the status of Sql server agent   R  
82   GET_DBUTIL_MSQ   retrieve data available from issuing a dbcc or simple sp command   R  
83   EXEC_SQLCMD_MSQ   MS SQL Server function to execute sql command   R  
84   MSS_PARAMSTRING_FROM_SQLTEXT   MS SQL server function to get parameter string from sqltext   R  
85   MSS_GET_SQLTEXT_BY_HANDLE   MS SQL server function to get sqltext from sys.dm_exec_sql_text   R  
86   MSS_GET_SQLREQUESTS   retrieve the contents of sys.dm_exe_query_stats   R  
87   MSS_GET_ABAPLOC_OBJECT   return abap and object given the dbsl's comment string    
       
Transaction Code
There is no transaction reference to this program  
History
Last changed by/on SAP  20100421 
SAP Release Created in