DISCOVER_OBJECT_MEMORY_USAGE Rowset

DISCOVER_OBJECT_MEMORY_USAGE Rowset

 

Applies To: SQL Server 2016 Preview

Provides information about memory resources used by objects.

The DISCOVER_OBJECT_MEMORY_USAGE rowset contains the following columns.

Column nameType indicatorLengthDescription
OBJECT_PARENT_PATHDBTYPE_WSTRThe path to the parent of the current object.
OBJECT_IDDBTYPE_WSTRThe ID of the object as defined at creation time.
OBJECT_MEMORY_SHRINKABLEDBTYPE_I8The 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_NONSHRINKABLEDBTYPE_I8The 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_VERSIONDBTYPE_I4The metadata version number of the object. This number changes each time the object is altered.
OBJECT_DATA_VERSIONDBTYPE_I4The lineage number of the data in the object. This number increments each time the object is processed.
OBJECT_TYPE_IDDBTYPE_I4Reserved for internal use.
OBJECT_TIME_CREATEDDBTYPE_DBTIMESTAMPThe 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 nameType indicatorRestriction State
OBJECT_PARENT_PATHDBTYPE_WSTROptional.
OBJECT_IDDBTYPE_WSTROptional

XML for Analysis Schema Rowsets

Community Additions

ADD
Show:
© 2016 Microsoft