sa_diagnostic_connection table

The sa_diagnostic_connection table is owned by the dbo user, and has one row for every database connection that is active during the logging session. Connect and disconnect times, if they occur within the logging session, can be derived from the sa_diagnostic_request table.

Most of the values in this table mirror values of connection properties.

There are two versions of this table: sa_diagnostic_connection, and sa_tmp_diagnostic_connection.

Columns

Column name	Column type	Description
logging_session_id	UNSIGNED INT	A number uniquely identifying the logging session during which the diagnostic information was gathered.
connection_number	UNSIGNED INT	A number assigned by the database server to identify the user's connection to the database. This value reflects the value of the Number connection property.
connection_name	LONG VARCHAR	Optional name property for the connection. This value reflects the value of the Name connection property.
user_name	LONG VARCHAR	The name of the user connected to the database.
comm_link	CHAR(40)	Specifies the client-side network protocol options. This value reflects the value of the CommLinks connection property.
node_address	LONG VARCHAR	The node for the client in a client/server connection. This value reflects the value of the NodeAddress connection property.
appinfo	LONG VARCHAR	Information about the client process, such as the IP address of the client computer, the operating system it is running on, and so on. This value reflects the value of the AppInfo connection property.

sa_diagnostic_connection table

Columns

See also