Export (0) Print
Expand All

DISCOVER_OBJECT_ACTIVITY

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

The DISCOVER_OBJECT_ACTIVITY rowset contains the following columns.

Column name

Type indicator

Length

Description

OBJECT_AGGREGATION_HIT

DBTYPE_I8

 

The number of times an aggregation of the object has been hit since the start of the service.

OBJECT_AGGREGATION_MISS

DBTYPE_I8

 

The 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_MS

DBTYPE_I8

 

The CPU time, in milliseconds, consumed by the object since the beginning of the service.

OBJECT_DATA_VERSION

DBTYPE_I4

 

The lineage number of the data in the object; this number increments each time the object is processed.

OBJECT_HIT

DBTYPE_I8

 

The number of times the object has been hit in the cache since the start of the service.

OBJECT_ID

DBTYPE_WSTR

 

The ID of the object as defined at creation time

OBJECT_MISS

DBTYPE_I8

 

The number of times the object has been missed in the cache since the start of the service.

OBJECT_PARENT_PATH

DBTYPE_WSTR

 

The path to the parent of current object.

OBJECT_READ_KB

DBTYPE_I8

 

The accumulated value of data read by the object since the start of the service, in kilobytes.

OBJECT_READS

DBTYPE_I8

 

The accumulated number of read operations by the object since the start of the service.

OBJECT_ROWS_RETURNED

DBTYPE_I8

 

The number of rows returned by the object to the caller since the start of the service.

OBJECT_ROWS_SCANNED

DBTYPE_I8

 

The number of rows scanned by the object since the start of the service.

OBJECT_VERSION

DBTYPE_I4

 

The metadata version number of the object; this number changes every time the object is altered.

OBJECT_WRITE_KB

DBTYPE_I8

 

The accumulated value of data written by the object since the start of the service, in kilobytes.

OBJECT_WRITES

DBTYPE_I8

 

The 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 name

Type indicator

Restriction State

OBJECT_PARENT_PATH

DBTYPE_WSTR

Optional.

OBJECT_ID

DBTYPE_WSTR

Optional.

Community Additions

ADD
Show:
© 2014 Microsoft