SAP ABAP Table MSS_CONNECTION (sys.dm_exec_connections structure from SQL Server 9.0)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-MSS (Application Component) Microsoft SQL Server
     ⤷ STUN_MSS (Package) Package for new SQL Server monitoring objects

Basic Data

Table Category	INTTAB	Structure
Structure	MSS_CONNECTION	Table Relationship Diagram
Short Description	sys.dm_exec_connections structure from SQL Server 9.0

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	CONNECTIONID	☐	MSSCONNECTIONID	MSSUNIQIDENT	CHAR	36	0	SQL Server connection id
2	PARENT_CONNID	☐	MSSPARENTCONNID	MSSUNIQIDENT	CHAR	36	0	SQL Server parent connection id
3	CONN_SESSIONID	☐	MSSCONNSID		INT4	10	0	Session ID running on connection
4	CONNECT_TIME	☐	MSSCONNDATE		CHAR	24	0	Character representation of datetime YYYY-MM-DD HH:MM:SS:SSS
5	NET_TRANSPORT	☐	MSSNETRANSPORT	CHAR80	CHAR	80	0	The network transport type used by the connection
6	PROTOCOL_TYPE	☐	MSSPROTYPE	CHAR80	CHAR	80	0	The network transport protocol used by the connection
7	CONN_NUMREADS	☐	MSSCONNUMREADS		INT4	10	0	SQL Server connection number of reads over the connection
8	CONN_NUMWRITES	☐	MSSCONNUMWRITES		INT4	10	0	SQL Server conneciton number of writes over the connection
9	LAST_READ	☐	MSSCONNLASTRD		CHAR	24	0	Character representation of datetime YYYY-MM-DD HH:MM:SS:SSS
10	LAST_WRITE	☐	MSSCONNLASTWT		CHAR	24	0	Character representation of datetime YYYY-MM-DD HH:MM:SS:SSS
11	NET_PACKET_SIZE	☐	MSSPACKSZ		INT4	10	0	SQL Server packet size
12	CLIENT_NET_ADDR	☐	MSSCONNETADDR	CHAR40	CHAR	40	0	Connection network address

History

Last changed by/on	SAP	20110908
SAP Release Created in	700