DISCOVER_CONNECTIONS Rowset
Provides resource usage and activity information about the currently opened connections on the server.
Applies to: tabular models, multidimensional models
The DISCOVER_CONNECTIONS rowset contains the following columns.
|
Column name |
Type indicator |
Restrictions |
Description |
|---|---|---|---|
|
CONNECTION_ID |
DBTYPE_I4 |
Yes |
A unique number that identifies the connection. |
|
CONNECTION_USER_NAME |
DBTYPE_WSTR |
Yes |
The connection user name. |
|
CONNECTION_IMPERSONATED_USER_NAME |
DBTYPE_WSTR |
Yes |
Reserved for future use. Analysis Services always returns NULL for the value of CONNECTION_IMPERSONATED_USER_NAME. |
|
CONNECTION_HOST_NAME |
DBTYPE_WSTR |
Yes |
The name of the machine that initiated the connection. |
|
CONNECTION_HOST_APPLICATION |
DBTYPE_WSTR |
|
The name of the application that initiated the connection. |
|
CONNECTION_START_TIME |
DBTYPE_DBTIMESTAMP |
|
The server UTC date and time when the connection was initiated. |
|
CONNECTION_ELAPSED_TIME_MS |
DBTYPE_I8 |
Yes |
Elapsed time, in milliseconds, since the start of the connection. |
|
CONNECTION_LAST_COMMAND_START_TIME |
DBTYPE_DBTIMESTAMP |
|
The server UTC date and time when the last command initiated its execution. |
|
CONNECTION_LAST_COMMAND_END_TIME |
DBTYPE_DBTIMESTAMP |
|
The server UTC date and time when the last command finished its execution. |
|
CONNECTION_LAST_COMMAND_ELAPSED_TIME_MS |
DBTYPE_I8 |
Yes |
The elapsed time, in milliseconds, since the end of the last command executed. |
|
CONNECTION_IDLE_TIME_MS |
DBTYPE_I8 |
Yes |
The idle time, in milliseconds, since the start of the connection. |
|
CONNECTION_BYTES_SENT |
DBTYPE_I8 |
|
The accumulated number of bytes sent by the connection since the start of the connection. |
|
CONNECTION_DATA_BYTES_SENT |
DBTYPE_I8 |
|
The accumulated number of data bytes sent by the connection since the start of the connection. Data travels compressed within the connection; this value represents the expanded data sent. |
|
CONNECTION_BYTES_RECEIVED |
DBTYPE_I8 |
|
The accumulated number of bytes received by the connection since the start of the connection. |
|
CONNECTION_DATA_BYTES_RECEIVED |
DBTYPE_I8 |
|
The accumulated number of data bytes received by the connection since the start of the connection. Data travels compressed within the connection; this value represents the expanded data received. |
This schema rowset is not sorted.
When using ADOMD.NET and the schema rowset to retrieve metadata, you can use either the GUID or string to reference a schema rowset object in the GetSchemaDataSet method. For more information, see Working with Schema Rowsets in ADOMD.NET.
The following table provides the GUID and string values that identify this rowset.
|
Argument |
Value |
|---|---|
|
GUID |
a07ccd25-8148-11d0-87bb-00c04fc33942 |
|
ADOMDNAME |
Connections |
