DISCOVER_TRANSACTIONS Rowset

 

Applies To: SQL Server 2016 Preview

Returns the current set of pending transactions on the system.

Applies to: tabular models, multidimensional models

The DISCOVER_TRANSACTIONS rowset contains the following columns.

Column nameType indicatorDescription
TRANSACTION_IDDBTYPE_WSTRThe transaction unique identifier, as a GUID.
TRANSACTION_SESSION_IDDBTYPE_WSTRThe transaction session unique identifier, as a GUID.
TRANSACTION_START_TIMEDBTYPE_DBTIMESTAMPThe server UTC date and time when the transaction was started.
TRANSACTION_ELAPSED_TIME_MSDBTYPE_I8The elapsed time, in milliseconds, since the start of the transaction.
TRANSACTION_CPU_TIME_MSDBTYPE_I8The CPU time, in milliseconds, consumed by all requests since the beginning of the transaction.

This schema rowset is not sorted.

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

Column nameType indicatorRestriction State
IDDBTYPE_WSTROptional.
SESSION_IDDBTYPE_WSTROptional.

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.

ArgumentValue
GUIDa07ccd28-8148-11d0-87bb-00c04fc33942
StringDISCOVER_TRANSACTIONS

XML for Analysis Schema Rowsets

Community Additions

ADD
Show: