DISCOVER_TRANSACTIONS Rowset

Returns the current set of pending transactions on the system.

Applies to: tabular models, multidimensional models

Rowset Columns

The DISCOVER_TRANSACTIONS rowset contains the following columns.

Column name

Type indicator

Description

TRANSACTION_ID

DBTYPE_WSTR

The transaction unique identifier, as a GUID.

TRANSACTION_SESSION_ID

DBTYPE_WSTR

The transaction session unique identifier, as a GUID.

TRANSACTION_START_TIME

DBTYPE_DBTIMESTAMP

The server UTC date and time when the transaction was started.

TRANSACTION_ELAPSED_TIME_MS

DBTYPE_I8

The elapsed time, in milliseconds, since the start of the transaction.

TRANSACTION_CPU_TIME_MS

DBTYPE_I8

The CPU time, in milliseconds, consumed by all requests since the beginning of the transaction.

This schema rowset is not sorted.

Restriction Columns

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

Column name

Type indicator

Restriction State

ID

DBTYPE_WSTR

Optional.

SESSION_ID

DBTYPE_WSTR

Optional.

Using ADOMD.NET to return the rowset

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

a07ccd28-8148-11d0-87bb-00c04fc33942

String

DISCOVER_TRANSACTIONS

See Also

Reference

XML for Analysis Schema Rowsets