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