SAP ABAP Class CL_MSS_ACTION (MS SQL Server: New monitoring)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-DB-MSS (Application Component) Microsoft SQL Server
⤷
STUN_MSS (Package) Package for new SQL Server monitoring objects
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-DB-MSS (Application Component) Microsoft SQL Server⤷
STUN_MSS (Package) Package for new SQL Server monitoring objectsMeta Relationship - Using
| # | Relationship type | Using | Short Description | Created on |
|---|---|---|---|---|
| 1 | Inheritance (c INHERITING FROM c_ref) | CL_DBA_ACTION | Meta data for DB-dependent DBA actions | 20031126 |
Properties
| Class | CL_MSS_ACTION | |
| Short Description | MS SQL Server: New monitoring | |
| Super Class | CL_DBA_ACTION | Meta data for DB-dependent DBA actions |
| Instantiability of a Class | 2 | Public |
| Final |
General Data
| Message Class | ||
| Program status | ||
| Category | 0 | |
| Package | STUN_MSS | Package for new SQL Server monitoring objects |
| Created | 20031126 | SAP |
| Last change | 20140121 | SAP |
| Shared Memory-enabled | ||
| Fixed point arithmetic | ||
| Unicode checks active |
Forward declarations
Class CL_MSS_ACTION has no forward declaration.
Interfaces
Class CL_MSS_ACTION has no interface implemented.
Friends
Class CL_MSS_ACTION has no friend class.
Attributes
| # | Attribute | Level | Visibility | Read only | Typing | Associated Type | Initial Value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | DBATASK_DATA_ADDITIONAL |
Constant | Public | Type reference (TYPE) | I | 55 | Data, additional functions | 20060519 | |
| 2 | DBATASK_PERFORMANCE_ADDITIONAL |
Constant | Public | Type reference (TYPE) | I | 53 | Additional Functions branch | 20060517 | |
| 3 | DBATASK_PERFORMANCE_INDEXES |
Constant | Public | Type reference (TYPE) | I | 43 | Indexes branch under Performance | 20060127 | |
| 4 | MSSACT_CFG_CONFOPT |
Constant | Public | Type reference (TYPE) | I | 61 | Configuration Options | 20070511 | |
| 5 | MSSACT_CFG_DBOPT |
Constant | Public | Type reference (TYPE) | I | 62 | Database Options | 20070511 | |
| 6 | MSSACT_CFG_MONITOR_SETTINGS |
Constant | Public | Type reference (TYPE) | I | 41 | Maintain Monitor Settings | 20051013 | |
| 7 | MSSACT_CFG_OVERVIEW |
Constant | Public | Type reference (TYPE) | I | 60 | Configuration Overview | 20070417 | |
| 8 | MSSACT_DB12 |
Constant | Public | Type reference (TYPE) | I | 21 | DB12 | 20041116 | |
| 9 | MSSACT_DB12_AGENT_JOBS |
Constant | Public | Type reference (TYPE) | I | 36 | SQL Server Agent jobs | 20050701 | |
| 10 | MSSACT_DB12_AGENT_PROPERTIES |
Constant | Public | Type reference (TYPE) | I | 32 | SQL Agent Properties | 20050701 | |
| 11 | MSSACT_DB12_BACKUP_HISTORY |
Constant | Public | Type reference (TYPE) | I | 35 | Database Backup History | 20050701 | |
| 12 | MSSACT_DB12_BKUP_DEVICES |
Constant | Public | Type reference (TYPE) | I | 31 | Backup Devices | 20050630 | |
| 13 | MSSACT_DB12_RESTORE_HISTORY |
Constant | Public | Type reference (TYPE) | I | 34 | Database Restore History | 20050701 | |
| 14 | MSSACT_DB12_RESTORE_TAPES |
Constant | Public | Type reference (TYPE) | I | 33 | Tapes needed for Restore | 20050701 | |
| 15 | MSSACT_DB12_SCHJOBS |
Constant | Public | Type reference (TYPE) | I | 29 | Scheduled jobs | 20050507 | |
| 16 | MSSACT_DB13 |
Constant | Public | Type reference (TYPE) | I | 22 | DB13 | 20041116 | |
| 17 | MSSACT_DL_PACKAGES |
Constant | Public | Type reference (TYPE) | I | 80 | Download Packages | 20120620 | |
| 18 | MSSACT_DOWNLOAD |
Constant | Public | Type reference (TYPE) | I | 74 | Download selected spreadsheets | 20091009 | |
| 19 | MSSACT_DOWNLOAD_ALL |
Constant | Public | Type reference (TYPE) | I | 75 | Download all available spreadsheets | 20100202 | |
| 20 | MSSACT_JOBS_CHKDBFILE |
Constant | Public | Type reference (TYPE) | I | 67 | Checkdb log history | 20080314 | |
| 21 | MSSACT_MEMORY_OVERVIEW |
Constant | Public | Type reference (TYPE) | I | 71 | Memory overview | 20130313 | |
| 22 | MSSACT_MSSPROCS |
Constant | Public | Type reference (TYPE) | I | 57 | SQL script maintenance (MSSPROCS) | 20061031 | |
| 23 | MSSACT_PACKAGE_VIEWER |
Constant | Public | Type reference (TYPE) | I | 81 | Performance package viewer | 20121113 | |
| 24 | MSSACT_SQLSTMT_SESSION |
Constant | Public | Type reference (TYPE) | I | 78 | SQL Statement for single abap in a new window | 20110315 | |
| 25 | MSSACT_ST04_BACKUPHIST |
Constant | Public | Type reference (TYPE) | I | 15 | 20040114 | ||
| 26 | MSSACT_ST04_COLLECTOR |
Constant | Public | Type reference (TYPE) | I | 68 | Current collector data | 20080509 | |
| 27 | MSSACT_ST04_COLLECTOR_HIST |
Constant | Public | Type reference (TYPE) | I | 69 | Collector historical data | 20080509 | |
| 28 | MSSACT_ST04_DBCOLLECTOR |
Constant | Public | Type reference (TYPE) | I | 6 | 20040109 | ||
| 29 | MSSACT_ST04_DBSZHIST |
Constant | Public | Type reference (TYPE) | I | 26 | Database size history | 20050420 | |
| 30 | MSSACT_ST04_DEADLOCK |
Constant | Public | Type reference (TYPE) | I | 17 | 20040115 | ||
| 31 | MSSACT_ST04_DEADLOCKS |
Constant | Public | Type reference (TYPE) | I | 2 | Deadlocks | 20031208 | |
| 32 | MSSACT_ST04_DISPTRIGGERS |
Constant | Public | Type reference (TYPE) | I | 38 | Display Triggers | 20050811 | |
| 33 | MSSACT_ST04_DISPTRIGGERS_TAB |
Constant | Public | Type reference (TYPE) | I | 70 | Display triggers for a single table | 20080509 | |
| 34 | MSSACT_ST04_DLLCONSISTENCY |
Constant | Public | Type reference (TYPE) | I | 19 | 20040115 | ||
| 35 | MSSACT_ST04_ERRORLOGS |
Constant | Public | Type reference (TYPE) | I | 13 | 20040114 | ||
| 36 | MSSACT_ST04_EXPLAINSTMT |
Constant | Public | Type reference (TYPE) | I | 20 | 20040115 | ||
| 37 | MSSACT_ST04_GUIDSETTING |
Constant | Public | Type reference (TYPE) | I | 39 | Show GUID env variable | 20050812 | |
| 38 | MSSACT_ST04_IDXOPSTATS |
Constant | Public | Type reference (TYPE) | I | 45 | Indexes with high operational statistics | 20060127 | |
| 39 | MSSACT_ST04_IDXRECOMMEND |
Constant | Public | Type reference (TYPE) | I | 46 | Indexes recommended by SQL Server | 20060127 | |
| 40 | MSSACT_ST04_IDXUSAGE |
Constant | Public | Type reference (TYPE) | I | 44 | Indexes with high usage | 20060127 | |
| 41 | MSSACT_ST04_IDX_ANALYZE |
Constant | Public | Type reference (TYPE) | I | 79 | Single table index analysis | 20110729 | |
| 42 | MSSACT_ST04_IOPERFILE |
Constant | Public | Type reference (TYPE) | I | 4 | IO per file | 20040106 | |
| 43 | MSSACT_ST04_LOCKSTATS |
Constant | Public | Type reference (TYPE) | I | 12 | 20040114 | ||
| 44 | MSSACT_ST04_LOCKWAITS |
Constant | Public | Type reference (TYPE) | I | 11 | 20040114 | ||
| 45 | MSSACT_ST04_NONSAP |
Constant | Public | Type reference (TYPE) | I | 72 | Non-SAP Features | 20090220 | |
| 46 | MSSACT_ST04_ONE_TABSZHIST |
Constant | Public | Type reference (TYPE) | I | 66 | Show table size histor for one table | 20080201 | |
| 47 | MSSACT_ST04_ONLIDXSETTING |
Constant | Public | Type reference (TYPE) | I | 40 | Show/set On-Line index creation settings | 20050812 | |
| 48 | MSSACT_ST04_OVERVIEW |
Constant | Public | Type reference (TYPE) | I | 1 | Entrance screen for ST04 | 20031205 | |
| 49 | MSSACT_ST04_PARAMETER |
Constant | Public | Type reference (TYPE) | I | 18 | 20040115 | ||
| 50 | MSSACT_ST04_PARAMETER_DETAIL |
Constant | Public | Type reference (TYPE) | I | 59 | SQL Server Parameter details | 20070201 | |
| 51 | MSSACT_ST04_PROFILER |
Constant | Public | Type reference (TYPE) | I | 16 | 20040115 | ||
| 52 | MSSACT_ST04_PROFILER_DETAIL |
Constant | Public | Type reference (TYPE) | I | 58 | SQL Profiler trace details | 20070130 | |
| 53 | MSSACT_ST04_QA_INIT |
Constant | Public | Type reference (TYPE) | I | 50 | Query Analyzer with an empty command | 20060502 | |
| 54 | MSSACT_ST04_QUERY_ANALYZER |
Constant | Public | Type reference (TYPE) | I | 27 | Query analyzer and Explain | 20050422 | |
| 55 | MSSACT_ST04_SQLPROCESSES |
Constant | Public | Type reference (TYPE) | I | 9 | 20040114 | ||
| 56 | MSSACT_ST04_SQLREQUEST |
Constant | Public | Type reference (TYPE) | I | 3 | SQL requests | 20031209 | |
| 57 | MSSACT_ST04_SQLSETUP |
Constant | Public | Type reference (TYPE) | I | 42 | Check SQL Server setup | 20060105 | |
| 58 | MSSACT_ST04_STATEONDISK |
Constant | Public | Type reference (TYPE) | I | 5 | 20040107 | ||
| 59 | MSSACT_ST04_STATS |
Constant | Public | Type reference (TYPE) | I | 65 | Show and update table data statistics | 20070727 | |
| 60 | MSSACT_ST04_STMT_HIST |
Constant | Public | Type reference (TYPE) | I | 76 | SQL Statement history | 20100804 | |
| 61 | MSSACT_ST04_SYSTEMTABLES |
Constant | Public | Type reference (TYPE) | I | 14 | 20040114 | ||
| 62 | MSSACT_ST04_TABLEDETAIL |
Constant | Public | Type reference (TYPE) | I | 30 | Single Table Analysis | 20050519 | |
| 63 | MSSACT_ST04_TABSZHIST |
Constant | Public | Type reference (TYPE) | I | 28 | Top n modified tables | 20050422 | |
| 64 | MSSACT_ST04_TEST |
Constant | Public | Type reference (TYPE) | I | 54 | Testing | 20060517 | |
| 65 | MSSACT_ST04_TOPGROWING |
Constant | Public | Type reference (TYPE) | I | 23 | Top n growing tables | 20050419 | |
| 66 | MSSACT_ST04_TOPLARGE |
Constant | Public | Type reference (TYPE) | I | 24 | Top n largest tables | 20050420 | |
| 67 | MSSACT_ST04_TOPMOD |
Constant | Public | Type reference (TYPE) | I | 25 | Top n modified tables | 20050420 | |
| 68 | MSSACT_ST04_VIEWDETAIL |
Constant | Public | Type reference (TYPE) | I | 52 | Analyze view | 20060509 | |
| 69 | MSSACT_ST04_WAITSTATS |
Constant | Public | Type reference (TYPE) | I | 48 | Server wait statistics | 20060501 | |
| 70 | MSSACT_XPL_SESSION |
Constant | Public | Type reference (TYPE) | I | 77 | Explain in a new window | 20110311 | |
| 71 | MSSPRIV_04 |
Constant | Public | Type reference (TYPE) | I | 4 | Reserved | 20090112 | |
| 72 | MSSPRIV_05 |
Constant | Public | Type reference (TYPE) | I | 5 | Reserved | 20090112 | |
| 73 | MSSPRIV_06 |
Constant | Public | Type reference (TYPE) | I | 6 | Reserved | 20090112 | |
| 74 | MSSPRIV_07 |
Constant | Public | Type reference (TYPE) | I | 7 | Reserved | 20090112 | |
| 75 | MSSPRIV_08 |
Constant | Public | Type reference (TYPE) | I | 8 | Reserved | 20090112 | |
| 76 | MSSPRIV_09 |
Constant | Public | Type reference (TYPE) | I | 9 | Reserved | 20090112 | |
| 77 | MSSPRIV_10 |
Constant | Public | Type reference (TYPE) | I | 10 | Reserved | 20090112 | |
| 78 | MSSPRIV_11 |
Constant | Public | Type reference (TYPE) | I | 11 | Reserved | 20090112 | |
| 79 | MSSPRIV_12 |
Constant | Public | Type reference (TYPE) | I | 12 | Reserved | 20090112 | |
| 80 | MSSPRIV_13 |
Constant | Public | Type reference (TYPE) | I | 13 | Reserved | 20090112 | |
| 81 | MSSPRIV_14 |
Constant | Public | Type reference (TYPE) | I | 14 | Reserved | 20090112 | |
| 82 | MSSPRIV_15 |
Constant | Public | Type reference (TYPE) | I | 15 | Reserved | 20090112 | |
| 83 | MSSPRIV_16 |
Constant | Public | Type reference (TYPE) | I | 16 | Reserved | 20090112 | |
| 84 | MSSPRIV_17 |
Constant | Public | Type reference (TYPE) | I | 17 | Reserved | 20090112 | |
| 85 | MSSPRIV_18 |
Constant | Public | Type reference (TYPE) | I | 18 | Reserved | 20090112 | |
| 86 | MSSPRIV_19 |
Constant | Public | Type reference (TYPE) | I | 19 | Rseerved | 20090112 | |
| 87 | MSSPRIV_20 |
Constant | Public | Type reference (TYPE) | I | 20 | Reserved | 20090112 | |
| 88 | MSSPRIV_21 |
Constant | Public | Type reference (TYPE) | I | 21 | Reserved | 20090112 | |
| 89 | MSSPRIV_22 |
Constant | Public | Type reference (TYPE) | I | 22 | Reserved | 20090112 | |
| 90 | MSSPRIV_23 |
Constant | Public | Type reference (TYPE) | I | 23 | Reserved | 20090112 | |
| 91 | MSSPRIV_ALTTRACE |
Constant | Public | Type reference (TYPE) | I | 3 | ALTER TRACE privilege | 20091024 | |
| 92 | MSSPRIV_CMDSHELL |
Constant | Public | Type reference (TYPE) | I | 2 | xp_cmdshell is configured | 20090313 | |
| 93 | MSSPRIV_IMPERS_DBO |
Constant | Public | Type reference (TYPE) | I | 1 | Impersonate dbo privilege | 20090112 | |
| 94 | MSSPRIV_SYSADMIN |
Constant | Public | Type reference (TYPE) | I | 0 | User is dbo | 20090112 | |
| 95 | MSSTASK_DOWNLOAD |
Constant | Public | Type reference (TYPE) | I | 73 | Download Menu | 20091009 | |
| 96 | TREETAB |
Instance attribute | Private | Type reference (TYPE) | MSSTREETAB | Actions & node enablement | 20070323 |
Methods
| # | Method | Level | Visibility | Method type | Description | Created on |
|---|---|---|---|---|---|---|
| 1 | CONSTRUCTOR |
Instance method | Public | Constructor | Redefining actions | 20031202 |
| 2 | INIT_MSSTREE |
Instance method | Private | Method | Initialize MSSTREE structure | 20070323 |
Events
Class CL_MSS_ACTION has no event.
Types
Class CL_MSS_ACTION has no local type.
Method Signatures
Method CONSTRUCTOR Signature
Method CONSTRUCTOR on class CL_MSS_ACTION has no parameter.
Method CONSTRUCTOR on class CL_MSS_ACTION has no exception.
Method INIT_MSSTREE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  Changing |
NODE | Call by reference | Type reference (TYPE) | MSSTREE | MSSTREE structure to be initialized | 20070323 |
Method INIT_MSSTREE on class CL_MSS_ACTION has no exception.
History
| Last changed by/on | SAP | 20140121 |
| SAP Release Created in | 700 |
