SAP Table MSS_CONNECTION
sys.dm_exec_connections structure from SQL Server 9.0
MSS_CONNECTION (sys.dm_exec_connections 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_CONNECTION to other SAP tables.
MSS_CONNECTION table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| CONNECTIONID | SQL Server connection id | MSSCONNECTIONID | CHAR | 36 | 0 | |||
| PARENT_CONNID | SQL Server parent connection id | MSSPARENTCONNID | CHAR | 36 | 0 | |||
| CONN_SESSIONID | Session ID running on connection | MSSCONNSID | INT4 | 10 | 0 | |||
| CONNECT_TIME | Character representation of datetime YYYY-MM-DD HH:MM:SS:SSS | MSSCONNDATE | CHAR | 24 | 0 | |||
| NET_TRANSPORT | The network transport type used by the connection | MSSNETRANSPORT | CHAR | 80 | 0 | |||
| PROTOCOL_TYPE | The network transport protocol used by the connection | MSSPROTYPE | CHAR | 80 | 0 | |||
| CONN_NUMREADS | SQL Server connection number of reads over the connection | MSSCONNUMREADS | INT4 | 10 | 0 | |||
| CONN_NUMWRITES | SQL Server conneciton number of writes over the connection | MSSCONNUMWRITES | INT4 | 10 | 0 | |||
| LAST_READ | Character representation of datetime YYYY-MM-DD HH:MM:SS:SSS | MSSCONNLASTRD | CHAR | 24 | 0 | |||
| LAST_WRITE | Character representation of datetime YYYY-MM-DD HH:MM:SS:SSS | MSSCONNLASTWT | CHAR | 24 | 0 | |||
| NET_PACKET_SIZE | SQL Server packet size | MSSPACKSZ | INT4 | 10 | 0 | |||
| CLIENT_NET_ADDR | Connection network address | MSSCONNETADDR | CHAR | 40 | 0 | |||
