Data Element list used by SAP ABAP Table MSS_ACTIVE_REQUEST (Active SQL Server requests with their connections & sessions)
SAP ABAP Table 
MSS_ACTIVE_REQUEST (Active SQL Server requests with their connections & sessions) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 |  Data Element |
ABP_CONT | Offset of a Processing Control Block | |
| 2 | Data Element |
MSQAPPPROG | Name of the application program which owns the connection. | |
| 3 | Data Element |
MSQEXECMD | Command currently being executed by the given process id | |
| 4 | Data Element |
MSQHOSTNE | Hostname of the application server logged into SQL Server. | |
| 5 | Data Element |
MSQNTDOMA | NT domain for the client connected to SQL Server. | |
| 6 | Data Element |
MSQNTUNAME | Windows NT user name for the process connected to SQL Server | |
| 7 | Data Element |
MSQPRLGTME | The time at which client process logged into SQL Server. | |
| 8 | Data Element |
MSQPRMEMUS | The pages allocated by the SQL process in procedure cache. | |
| 9 | Data Element |
MSQPROSTAT | SQL Server process status; ie sleeping, running etc. | |
| 10 | Data Element |
MSQSAPWAIT | Name of the locked resource the process is waiting for. | |
| 11 | Data Element |
MSQSQLWAIT | The locked resource process is waiting for (object ID). | |
| 12 | Data Element |
MSQUSRNAME | The user name used to log into the SQL Server database | |
| 13 | Data Element |
MSQUSRNAME | The user name used to log into the SQL Server database | |
| 14 | Data Element |
MSQWAITIME | Current wait time of the process in milliseconds | |
| 15 | Data Element |
MSSABNAME | Name of the ABAP report | |
| 16 | Data Element |
MSSBLKSESSIONID | Blocking session ID for SQL Server | |
| 17 | Data Element |
MSSCONNDATE | Character representation of datetime YYYY-MM-DD HH:MM:SS:SSS | |
| 18 | Data Element |
MSSCONNECTIONID | SQL Server connection id | |
| 19 | Data Element |
MSSCONNETADDR | Connection network address | |
| 20 | Data Element |
MSSCONNLASTRD | Character representation of datetime YYYY-MM-DD HH:MM:SS:SSS | |
| 21 | Data Element |
MSSCONNLASTWT | Character representation of datetime YYYY-MM-DD HH:MM:SS:SSS | |
| 22 | Data Element |
MSSCONNSID | Session ID running on connection | |
| 23 | Data Element |
MSSCONNUMREADS | SQL Server connection number of reads over the connection | |
| 24 | Data Element |
MSSCONNUMWRITES | SQL Server conneciton number of writes over the connection | |
| 25 | Data Element |
MSSCPUTIME | MS SQL Server cumulative cpu time | |
| 26 | Data Element |
MSSDB | Database name | |
| 27 | Data Element |
MSSESSCHTIME | SQL Server session scheduled time | |
| 28 | Data Element |
MSSESSELPTIME | SQL Server session elapsed time | |
| 29 | Data Element |
MSSESTCMPTIME | Estimated Completion time of SQL Request | |
| 30 | Data Element |
MSSHPID | Process ID on app. server | |
| 31 | Data Element |
MSSINT4 | SQL Server int4 | |
| 32 | Data Element |
MSSINT4 | SQL Server int4 | |
| 33 | Data Element |
MSSNETRANSPORT | The network transport type used by the connection | |
| 34 | Data Element |
MSSNUMLOGREADS | Total number of reads performed | |
| 35 | Data Element |
MSSNUMREADS | Total number of reads performed by a session and request | |
| 36 | Data Element |
MSSNUMWRITES | Total number of writes performed | |
| 37 | Data Element |
MSSOBJNAME | MS SQL Server object name | |
| 38 | Data Element |
MSSOPENRES | Number of open result sets for the SQL Server process | |
| 39 | Data Element |
MSSOPENTRAN | Number of open transactions for the SQL Server process | |
| 40 | Data Element |
MSSPACKSZ | SQL Server packet size | |
| 41 | Data Element |
MSSPARENTCONNID | SQL Server parent connection id | |
| 42 | Data Element |
MSSPARTIALSQL | First 50 characters of a SQL Server statement | |
| 43 | Data Element |
MSSPLANHANDLE | handle pointing to plan used in execution of sql stmt/proc | |
| 44 | Data Element |
MSSPRCCOMP | Percentage complete | |
| 45 | Data Element |
MSSPROTYPE | The network transport protocol used by the connection | |
| 46 | Data Element |
MSSREQCONNID | SQL Server connection id | |
| 47 | Data Element |
MSSREQCPUTIME | CPU time for a request | |
| 48 | Data Element |
MSSREQDATE | Character representation of datetime YYYY-MM-DD HH:MM:SS:SSS | |
| 49 | Data Element |
MSSREQNUMLOGRDS | number of reads performed by a request | |
| 50 | Data Element |
MSSREQNUMREADS | number of reads performed by the request | |
| 51 | Data Element |
MSSREQNUMWRITES | number of writes performed in a request | |
| 52 | Data Element |
MSSREQSCHEDULERID | ID of the scheduler used for the request | |
| 53 | Data Element |
MSSREQSID | Session ID associated with the request being processed | |
| 54 | Data Element |
MSSREQTTL | Total elapsed time utilized by a request | |
| 55 | Data Element |
MSSREQUESTID | SQL Server Request ID | |
| 56 | Data Element |
MSSROWCOUNT | SQL Server count of rows returned | |
| 57 | Data Element |
MSSSAPUSER | The user name in the SAP system. | |
| 58 | Data Element |
MSSSESCPUTIME | CPU time for a SQL session (ms) | |
| 59 | Data Element |
MSSSESNUMLOGRDS | number of reads performed by a session | |
| 60 | Data Element |
MSSSESNUMREADS | number of reads performed in a session | |
| 61 | Data Element |
MSSSESNUMWRITES | Number of writes performed in a session | |
| 62 | Data Element |
MSSSESSINTFNAME | MSS Session client interface name | |
| 63 | Data Element |
MSSSESSINTFVER | MSS Session client interface name | |
| 64 | Data Element |
MSSSESSIONID | Session ID for SQL Server | |
| 65 | Data Element |
MSSSQLHANDLE | handle pointing to sql statment or procedure | |
| 66 | Data Element |
MSSTRANSACTIONID | Transaction identifier request executes under | |
| 67 | Data Element |
MSSTRXISOLEVEL | MSS Transaction Isolation level | |
| 68 | Data Element |
MSSWPNAME | ID of the R3 work process |
