sys.dm_broker_connections
io #io#dmv
Description
Returns a row for each Service Broker network connection. The following table provides more Identifier of the SQL Server Network Interface (SNI) connection used by this connection for TCP/IP communications.
Syntax
NEW
CONNECTING
CONNECTED
LOGGED_IN
CLOSED connect_time