Export (0) Print
Expand All

DISCOVER_DB_CONNECTIONS Rowset

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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 name

Type indicator

Length

Description

CONNECTION_CATALOG_NAME

DBTYPE_WSTR

 

The database name of the currently connected database.

CONNECTION_ID

DBTYPE_I4

 

A unique number that identifies the connection.

CONNECTION_IDLE_TIME_MS

DBTYPE_I8

 

The idle time, in milliseconds, since the start of the connection.

CONNECTION_IN_USE

DBTYPE_I4

 

indicates whether the connection is active (1) or idle (0).

CONNECTION_LAST_COMMAND_END_TIME

DBTYPE_DBTIMESTAMP

 

The server UTC date and time when the last command finished its execution.

CONNECTION_LAST_COMMAND_START_TIME

DBTYPE_DBTIMESTAMP

 

The server UTC date and time when he last command initiated its execution.

CONNECTION_SERVER_NAME

DBTYPE_WSTR

 

The name of the currently connected server.

CONNECTION_SPID

DBTYPE_I4

 

The session ID.

CONNECTION_START_TIME

DBTYPE_DBTIMESTAMP

 

The server UTC date and time when the connection was initiated.

CONNECTION_USAGE_TIME_MS

DBTYPE_I8

 

The connection active time, in milliseconds, since the start of the connection.

This schema rowset is not sorted.

Important note 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 name

Type indicator

Restriction State

CONNECTION_ID

DBTYPE_I4

Optional.

CONNECTION_IN_USE

DBTYPE_I4

Optional.

CONNECTION_SERVER_NAME

DBTYPE_WSTR

Optional.

CONNECTION_CATALOG_NAME

DBTYPE_WSTR

Required.

CONNECTION_SPID

DBTYPE_I4

Optional.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft