SAP Table MSS_SESSION
/sys.dm_exec_sessions structure from SQL Server 9.0
MSS_SESSION (/sys.dm_exec_sessions structure from SQL Server 9.0) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link MSS_SESSION to other SAP tables.
MSS_SESSION table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| SESSIONID | Session ID for SQL Server | MSSSESSIONID | INT4 | 10 | 0 | |||
| LOGINTIME | The time at which client process logged into SQL Server. | MSQPRLGTME | CHAR | 24 | 0 | |||
| HOSTNAME | Hostname of the application server logged into SQL Server. | MSQHOSTNE | CHAR | 128 | 0 | |||
| PROGNAME | Name of the application program which owns the connection. | MSQAPPPROG | CHAR | 256 | 0 | |||
| HOSTPID | Process ID on app. server | MSSHPID | INT4 | 10 | 0 | |||
| CLIENTINFVER | MSS Session client interface name | MSSSESSINTFVER | INT4 | 10 | 0 | |||
| CLIENTINFNAME | MSS Session client interface name | MSSSESSINTFNAME | CHAR | 64 | 0 | |||
| LOGINNAME | The user name used to log into the SQL Server database | MSQUSRNAME | CHAR | 128 | 0 | |||
| NTDOMAIN | NT domain for the client connected to SQL Server. | MSQNTDOMA | CHAR | 256 | 0 | |||
| NTUNAME | Windows NT user name for the process connected to SQL Server | MSQNTUNAME | CHAR | 256 | 0 | |||
| CPUTIME | CPU time for a SQL session (ms) | MSSSESCPUTIME | INT4 | 10 | 0 | |||
| MEMUSAGE | The pages allocated by the SQL process in procedure cache. | MSQPRMEMUS | INT4 | 10 | 0 | |||
| TTLSCHEDTIME | SQL Server session scheduled time | MSSESSCHTIME | INT4 | 10 | 0 | |||
| TTLELAPSEDTIME | SQL Server session elapsed time | MSSESSELPTIME | INT4 | 10 | 0 | |||
| SESS_NUMREADS | number of reads performed in a session | MSSSESNUMREADS | DEC | 20 | 0 | |||
| SESS_NUMWRITES | Number of writes performed in a session | MSSSESNUMWRITES | DEC | 20 | 0 | |||
| SESS_NUMLOGICALREADS | number of reads performed by a session | MSSSESNUMLOGRDS | DEC | 20 | 0 | |||
| TRXISOLEVEL | MSS Transaction Isolation level | MSSTRXISOLEVEL | CHAR | 12 | 0 | |||
