The Function Group SFMSS_MONITOR (MSSQL monitoring functions for rz20) is a standard Function Group in SAP ERP and is part of the package SMSS_ALERTS. It contains the following embedded function modules and dictionary objects.
| Function Group | SFMSS_MONITOR |
| Short Text | MSSQL monitoring functions for rz20 |
| Package | SMSS_ALERTS |
Function Group SFMSS_MONITOR contains 21 function modules.
| CCMS_MSS_APP_EXE_CHK | monitor slow sql statements by appserver |
|---|---|
| CCMS_MSS_APP_SLOW_SQL | monitor slow sql statements by appserver |
| CCMS_MSS_BACKUP_CHECK | Check for the last backup date |
| CCMS_MSS_BACKUP_RUNNING | check to see if a backup is currently running |
| CCMS_MSS_BACKUP_TLOG_CHECK | Check for the last transaction log backup time |
| CCMS_MSS_CONSIST_CHECK | check R/3 consistency by checking for missing items |
| CCMS_MSS_ERRORLOG_CHK | check error log messages |
| CCMS_MSS_HEALTH_SQLSETUP | SQL Server parameter setting check |
| CCMS_MSS_HEALTH_STARTUP | SQL Server parameter setting check |
| CCMS_MSS_PERF_DATACACHE | data cache hit ratio |
| CCMS_MSS_PERF_IO | data cache hit ratio |
| CCMS_MSS_PERF_PROCACHE | procedure cache hit ratio |
| CCMS_MSS_PERFHEALTH_CPU | display @@variables for cpu busy, disk errors, network packet errors |
| CCMS_MSS_REPORT_ERROR | report errors from ccms mss monitoring |
| CCMS_MSS_RFC_DLLDATA | call the cfgck rfc svr to get the dlls of disp+work.exe |
| CCMS_MSS_RFC_NETLIB | call the rfc server to get the registry setting of netlibs |
| CCMS_MSS_RFC_REG | registar the rfc server sap_mssql_cfgck with gw |
| CCMS_MSS_RFC_TRACERT | call fcn to get tracert to the database server |
| CCMS_MSS_RFC_UNREG | function to unregister the rfc svr with the gw |
| CCMS_MSS_SPACE_MGMT | present data on the files which make up the SQL Server Database |
| CCMS_MSS_SQLSETUP_STATUS | Check the status of the SQL Server setup |