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 |
|
|
|
|
|