Export (0) Print
Expand All

DISCOVER_DB_CONNECTIONS Rowset

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.

Community Additions

ADD
Show:
© 2014 Microsoft