Click to Rate and Give Feedback
MSDN
MSDN Library
SQL Server
SQL Server 2008
Technical Reference
Schema Rowsets
 DISCOVER_OBJECT_MEMORY_USAGE
Community Content
In this section
Statistics Annotations (0)
Collapse All/Expand All Collapse All
SQL Server 2008 Books Online (October 2009)
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 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 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

Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
Processing
© 2009 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks | Privacy Statement | Site Feedback
Page view tracker