Data Element list used by SAP ABAP Table MSS_SESSION (/sys.dm_exec_sessions structure from SQL Server 9.0)
SAP ABAP Table 
MSS_SESSION (/sys.dm_exec_sessions structure from SQL Server 9.0) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 |  Data Element |
MSQAPPPROG | Name of the application program which owns the connection. | |
| 2 | Data Element |
MSQHOSTNE | Hostname of the application server logged into SQL Server. | |
| 3 | Data Element |
MSQNTDOMA | NT domain for the client connected to SQL Server. | |
| 4 | Data Element |
MSQNTUNAME | Windows NT user name for the process connected to SQL Server | |
| 5 | Data Element |
MSQPRLGTME | The time at which client process logged into SQL Server. | |
| 6 | Data Element |
MSQPRMEMUS | The pages allocated by the SQL process in procedure cache. | |
| 7 | Data Element |
MSQUSRNAME | The user name used to log into the SQL Server database | |
| 8 | Data Element |
MSSESSCHTIME | SQL Server session scheduled time | |
| 9 | Data Element |
MSSESSELPTIME | SQL Server session elapsed time | |
| 10 | Data Element |
MSSHPID | Process ID on app. server | |
| 11 | Data Element |
MSSSESCPUTIME | CPU time for a SQL session (ms) | |
| 12 | Data Element |
MSSSESNUMLOGRDS | number of reads performed by a session | |
| 13 | Data Element |
MSSSESNUMREADS | number of reads performed in a session | |
| 14 | Data Element |
MSSSESNUMWRITES | Number of writes performed in a session | |
| 15 | Data Element |
MSSSESSINTFNAME | MSS Session client interface name | |
| 16 | Data Element |
MSSSESSINTFVER | MSS Session client interface name | |
| 17 | Data Element |
MSSSESSIONID | Session ID for SQL Server | |
| 18 | Data Element |
MSSTRXISOLEVEL | MSS Transaction Isolation level |
