MSS_ACTIVE_REQUEST SAP (Active SQL Server requests with their connections & sessions) Structure details
Description: Active SQL Server requests with their connections & sessions
Related tables to MSS_ACTIVE_REQUEST
Access table MSS_ACTIVE_REQUEST
Structure field list including key, data, relationships and ABAP select examples
MSS_ACTIVE_REQUEST is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Active SQL Server requests with their connections & sessions" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_MSS_ACTIVE_REQUEST TYPE MSS_ACTIVE_REQUEST.
The MSS_ACTIVE_REQUEST table consists of various fields, each holding specific information or linking keys about Active SQL Server requests with their connections & sessions data available in SAP. These include SESSIONID (Session ID for SQL Server), LOGINTIME (The time at which client process logged into SQL Server.), HOSTNAME (Hostname of the application server logged into SQL Server.), PROGNAME (Name of the application program which owns the connection.).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP MSS_ACTIVE_REQUEST structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
SESSIONID | Session ID for SQL Server | MSSSESSIONID | INT4 | 10 | MSSINT4 | ||||
LOGINTIME | The time at which client process logged into SQL Server. | MSQPRLGTME | CHAR | 24 | CHAR24 | ||||
HOSTNAME | Hostname of the application server logged into SQL Server. | MSQHOSTNE | CHAR | 128 | CHAR128 | ||||
PROGNAME | Name of the application program which owns the connection. | MSQAPPPROG | CHAR | 256 | CHAR256 | ||||
HOSTPID | Process ID on app. server | MSSHPID | INT4 | 10 | MSSINT4 | ||||
CLIENTINFVER | MSS Session client interface name | MSSSESSINTFVER | INT4 | 10 | |||||
CLIENTINFNAME | MSS Session client interface name | MSSSESSINTFNAME | CHAR | 64 | CHAR64 | ||||
LOGINNAME | The user name used to log into the SQL Server database | MSQUSRNAME | CHAR | 128 | CHAR128 | ||||
NTDOMAIN | NT domain for the client connected to SQL Server. | MSQNTDOMA | CHAR | 256 | CHAR256 | ||||
NTUNAME | Windows NT user name for the process connected to SQL Server | MSQNTUNAME | CHAR | 256 | CHAR256 | ||||
CPUTIME | CPU time for a SQL session (ms) | MSSSESCPUTIME | INT4 | 10 | INT4 | ||||
MEMUSAGE | The pages allocated by the SQL process in procedure cache. | MSQPRMEMUS | INT4 | 10 | INT4 | ||||
TTLSCHEDTIME | SQL Server session scheduled time | MSSESSCHTIME | INT4 | 10 | |||||
TTLELAPSEDTIME | SQL Server session elapsed time | MSSESSELPTIME | INT4 | 10 | |||||
SESS_NUMREADS | number of reads performed in a session | MSSSESNUMREADS | DEC | 20 | MSQBIGINT | ||||
SESS_NUMWRITES | Number of writes performed in a session | MSSSESNUMWRITES | DEC | 20 | MSQBIGINT | ||||
SESS_NUMLOGICALREADS | number of reads performed by a session | MSSSESNUMLOGRDS | DEC | 20 | MSQBIGINT | ||||
TRXISOLEVEL | MSS Transaction Isolation level | MSSTRXISOLEVEL | CHAR | 12 | |||||
CONNECTIONID | SQL Server connection id | MSSCONNECTIONID | CHAR | 36 | MSSUNIQIDENT | ||||
PARENT_CONNID | SQL Server parent connection id | MSSPARENTCONNID | CHAR | 36 | MSSUNIQIDENT | ||||
CONN_SESSIONID | Session ID running on connection | MSSCONNSID | INT4 | 10 | |||||
CONNECT_TIME | Character representation of datetime YYYY-MM-DD HH:MM:SS:SSS | MSSCONNDATE | CHAR | 24 | |||||
NET_TRANSPORT | The network transport type used by the connection | MSSNETRANSPORT | CHAR | 80 | CHAR80 | ||||
PROTOCOL_TYPE | The network transport protocol used by the connection | MSSPROTYPE | CHAR | 80 | CHAR80 | ||||
CONN_NUMREADS | SQL Server connection number of reads over the connection | MSSCONNUMREADS | INT4 | 10 | |||||
CONN_NUMWRITES | SQL Server conneciton number of writes over the connection | MSSCONNUMWRITES | INT4 | 10 | |||||
LAST_READ | Character representation of datetime YYYY-MM-DD HH:MM:SS:SSS | MSSCONNLASTRD | CHAR | 24 | |||||
LAST_WRITE | Character representation of datetime YYYY-MM-DD HH:MM:SS:SSS | MSSCONNLASTWT | CHAR | 24 | |||||
NET_PACKET_SIZE | SQL Server packet size | MSSPACKSZ | INT4 | 10 | |||||
CLIENT_NET_ADDR | Connection network address | MSSCONNETADDR | CHAR | 40 | CHAR40 | ||||
REQ_SESSIONID | Session ID associated with the request being processed | MSSREQSID | INT4 | 10 | |||||
REQUESTID | SQL Server Request ID | MSSREQUESTID | INT4 | 10 | |||||
START_TIME | Character representation of datetime YYYY-MM-DD HH:MM:SS:SSS | MSSREQDATE | CHAR | 24 | |||||
STATUS | SQL Server process status; ie sleeping, running etc. | MSQPROSTAT | CHAR | 60 | CHAR60 | ||||
COMMAND | Command currently being executed by the given process id | MSQEXECMD | CHAR | 32 | CHAR32 | ||||
SQLHANDLE | handle pointing to sql statment or procedure | MSSSQLHANDLE | CHAR | 130 | MSSHANDLE | ||||
STMT_START_OFFSET | SQL Server int4 | MSSINT4 | INT4 | 10 | |||||
STMT_END_OFFSET | SQL Server int4 | MSSINT4 | INT4 | 10 | |||||
PLAN_HANDLE | handle pointing to plan used in execution of sql stmt/proc | MSSPLANHANDLE | CHAR | 130 | MSSHANDLE | ||||
DBNAME | Database name | MSSDB | CHAR | 128 | MSSSYSNAME | ||||
USERNAME | The user name used to log into the SQL Server database | MSQUSRNAME | CHAR | 128 | CHAR128 | ||||
REQ_CONNECTIONID | SQL Server connection id | MSSREQCONNID | CHAR | 36 | MSSUNIQIDENT | ||||
BLOCKING_SESSION_ID | Blocking session ID for SQL Server | MSSBLKSESSIONID | INT4 | 10 | |||||
WAIT_TIME | Current wait time of the process in milliseconds | MSQWAITIME | INT4 | 10 | INT4 | ||||
LAST_WAIT_TYPE | The locked resource process is waiting for (object ID). | MSQSQLWAIT | CHAR | 64 | CHAR64 | ||||
WAIT_RESOURCE | Name of the locked resource the process is waiting for. | MSQSAPWAIT | CHAR | 255 | CHAR255 | ||||
OPEN_TRAN_CNT | Number of open transactions for the SQL Server process | MSSOPENTRAN | INT4 | 10 | |||||
OPEN_RESULTSET_CNT | Number of open result sets for the SQL Server process | MSSOPENRES | INT4 | 10 | |||||
TRANSACTION_ID | Transaction identifier request executes under | MSSTRANSACTIONID | DEC | 20 | MSQBIGINT | ||||
PERCENT_COMPLETE | Percentage complete | MSSPRCCOMP | DEC | 6(2) | |||||
EST_COMPLETION_TIME | Estimated Completion time of SQL Request | MSSESTCMPTIME | DEC | 20 | MSQBIGINT | ||||
REQ_CPUTIME | CPU time for a request | MSSREQCPUTIME | INT4 | 10 | INT4 | ||||
REQ_TTLTIME | Total elapsed time utilized by a request | MSSREQTTL | INT4 | 10 | |||||
SCHED_ID | ID of the scheduler used for the request | MSSREQSCHEDULERID | INT4 | 10 | |||||
REQ_NUMREADS | number of reads performed by the request | MSSREQNUMREADS | DEC | 20 | MSQBIGINT | ||||
REQ_NUMWRITES | number of writes performed in a request | MSSREQNUMWRITES | DEC | 20 | MSQBIGINT | ||||
REQ_NUMLOGICALREADS | number of reads performed by a request | MSSREQNUMLOGRDS | DEC | 20 | MSQBIGINT | ||||
REQ_ROWCOUNT | SQL Server count of rows returned | MSSROWCOUNT | DEC | 20 | MSQBIGINT | ||||
SQLTEXT | First 50 characters of a SQL Server statement | MSSPARTIALSQL | CHAR | 50 | TEXT50 | ||||
OBJECT_NAME | MS SQL Server object name | MSSOBJNAME | CHAR | 30 | TEXT30 | ||||
ABAP_NAME | Name of the ABAP report | MSSABNAME | CHAR | 40 | PROGNAME | ||||
ABAP_LOC | Offset of a Processing Control Block | ABP_CONT | INT4 | 10 | |||||
SAP_USER | The user name in the SAP system. | MSSSAPUSER | CHAR | 12 | |||||
CPU_TTL | MS SQL Server cumulative cpu time | MSSCPUTIME | INT4 | 10 | INT4 | ||||
READS_TTL | Total number of reads performed by a session and request | MSSNUMREADS | DEC | 20 | MSQBIGINT | ||||
WRTS_TTL | Total number of writes performed | MSSNUMWRITES | DEC | 20 | MSQBIGINT | ||||
LOGRDS_TTL | Total number of reads performed | MSSNUMLOGREADS | DEC | 20 | MSQBIGINT | ||||
WPNAME | ID of the R3 work process | MSSWPNAME | CHAR | 2 | CHAR2 |
Key field | Non-key field |
How do I retrieve data from SAP structure MSS_ACTIVE_REQUEST using ABAP code?
As MSS_ACTIVE_REQUEST is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on MSS_ACTIVE_REQUEST as there is no data to select.How to access SAP table MSS_ACTIVE_REQUEST
Within an ECC or HANA version of SAP you can also view further information about MSS_ACTIVE_REQUEST and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects