DISCOVER_OBJECT_ACTIVITY Rowset

DISCOVER_OBJECT_ACTIVITY Rowset

 

Applies To: SQL Server 2016 Preview

Provides resource usage per object since the start of the service.

The DISCOVER_OBJECT_ACTIVITY rowset contains the following columns.

Column nameType indicatorLengthDescription
OBJECT_AGGREGATION_HITDBTYPE_I8The number of times an aggregation of the object has been hit since the start of the service.
OBJECT_AGGREGATION_MISSDBTYPE_I8The number of times an exisiting aggregation, of the object, has not been missed (that is, has not been used) since the start of the service.
OBJECT_CPU_TIME_MSDBTYPE_I8The CPU time, in milliseconds, consumed by the object since the beginning of the service.
OBJECT_DATA_VERSIONDBTYPE_I4The lineage number of the data in the object; this number increments each time the object is processed.
OBJECT_HITDBTYPE_I8The number of times the object has been hit in the cache since the start of the service.
OBJECT_IDDBTYPE_WSTRThe ID of the object as defined at creation time
OBJECT_MISSDBTYPE_I8The number of times the object has been missed in the cache since the start of the service.
OBJECT_PARENT_PATHDBTYPE_WSTRThe path to the parent of current object.
OBJECT_READ_KBDBTYPE_I8The accumulated value of data read by the object since the start of the service, in kilobytes.
OBJECT_READSDBTYPE_I8The accumulated number of read operations by the object since the start of the service.
OBJECT_ROWS_RETURNEDDBTYPE_I8The number of rows returned by the object to the caller since the start of the service.
OBJECT_ROWS_SCANNEDDBTYPE_I8The number of rows scanned by the object since the start of the service.
OBJECT_VERSIONDBTYPE_I4The metadata version number of the object; this number changes every time the object is altered.
OBJECT_WRITE_KBDBTYPE_I8The accumulated value of data written by the object since the start of the service, in kilobytes.
OBJECT_WRITESDBTYPE_I8The accumulated number of write operations by the object since the start of the service.

This schema rowset is not sorted.

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

Column nameType indicatorRestriction State
OBJECT_PARENT_PATHDBTYPE_WSTROptional.
OBJECT_IDDBTYPE_WSTROptional.

XML for Analysis Schema Rowsets

Community Additions

ADD
Show:
© 2016 Microsoft