DISCOVER_DB_CONNECTIONS Rowset

DISCOVER_DB_CONNECTIONS Rowset

 

Applies To: SQL Server 2016 Preview

Provides resource usage and activity information about the currently opened connections from the server to a database.

The DISCOVER_DB_CONNECTIONS rowset contains the following columns.

Column nameType indicatorLengthDescription
CONNECTION_CATALOG_NAMEDBTYPE_WSTRThe database name of the currently connected database.
CONNECTION_IDDBTYPE_I4A unique number that identifies the connection.
CONNECTION_IDLE_TIME_MSDBTYPE_I8The idle time, in milliseconds, since the start of the connection.
CONNECTION_IN_USEDBTYPE_I4indicates whether the connection is active (1) or idle (0).
CONNECTION_LAST_COMMAND_END_TIMEDBTYPE_DBTIMESTAMPThe server UTC date and time when the last command finished its execution.
CONNECTION_LAST_COMMAND_START_TIMEDBTYPE_DBTIMESTAMPThe server UTC date and time when he last command initiated its execution.
CONNECTION_SERVER_NAMEDBTYPE_WSTRThe name of the currently connected server.
CONNECTION_SPIDDBTYPE_I4The session ID.
CONNECTION_START_TIMEDBTYPE_DBTIMESTAMPThe server UTC date and time when the connection was initiated.
CONNECTION_USAGE_TIME_MSDBTYPE_I8The connection active time, in milliseconds, since the start of the connection.

This schema rowset is not sorted.

System_CAPS_ICON_important.jpg Important


The DISCOVER_DB_CONNECTIONS rowset will only display information when the service is connected to the relational data sources.

The DISCOVER_DB_CONNECTIONS rowset can be restricted on the columns listed in the following table.

Column nameType indicatorRestriction State
CONNECTION_IDDBTYPE_I4Optional.
CONNECTION_IN_USEDBTYPE_I4Optional.
CONNECTION_SERVER_NAMEDBTYPE_WSTROptional.
CONNECTION_CATALOG_NAMEDBTYPE_WSTRRequired.
CONNECTION_SPIDDBTYPE_I4Optional.

XML for Analysis Schema Rowsets

Community Additions

ADD
Show:
© 2016 Microsoft