Export (0) Print
Expand All

DISCOVER_OBJECT_MEMORY_USAGE

Provides information about memory resources used by objects.

The DISCOVER_OBJECT_MEMORY_USAGE rowset contains the following columns.

Column name

Type indicator

Length

Description

OBJECT_PARENT_PATH

DBTYPE_WSTR

 

The path to the parent of the current object.

OBJECT_ID

DBTYPE_WSTR

 

The ID of the object as defined at creation time.

OBJECT_MEMORY_SHRINKABLE

DBTYPE_I8

 

The total amount of memory (bytes) used by all the shrinkable objects that are directly owned by the current object. The current value does not include memory from objects owned by named objects that are owned by the current object.

OBJECT_MEMORY_NONSHRINKABLE

DBTYPE_I8

 

The amount of memory (bytes) of all non-shrinkable objects directly owned by current object. The current value does not include memory from objects owned by named objects that are owned by current object.

OBJECT_VERSION

DBTYPE_I4

 

The metadata version number of the object. This number changes each time the object is altered.

OBJECT_DATA_VERSION

DBTYPE_I4

 

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

OBJECT_TYPE_ID

DBTYPE_I4

 

Reserved for internal use.

OBJECT_TIME_CREATED

DBTYPE_DBTIMESTAMP

 

The UTC server time at the moment the object was created.

This schema rowset is not sorted.

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